Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old June 15th, 2004, 03:12 PM
Authorized User
 
Join Date: Apr 2004
Location: , , .
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Making changes to DB on hosting server w/ VS.NET

Is there a way to syncronize a database on a hosting server with the DB on my development machine so that changes I make to the DB with VS.NET show up in the database on the hosting server?

Thanks in advance for your replies.

Dan
  #2 (permalink)  
Old June 15th, 2004, 07:11 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Do you mean the changes as the Data changes or Structural changes?
What changes do you make to DB with VS.NET?

It is not advisable to have the changes made to development environment get sync with live environment. What happens if by mistake you made a change on development server that affects the entire system and that get replicated to the live server too.

Cheers!

_________________________
-Vijay G
Strive for Perfection
  #3 (permalink)  
Old June 16th, 2004, 06:07 PM
Authorized User
 
Join Date: Apr 2004
Location: , , .
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by happygv
 Do you mean the changes as the Data changes or Structural changes?
What changes do you make to DB with VS.NET?
I meant things like adding stored procedures and tables as I build more and more functionality into the site.

Dan
  #4 (permalink)  
Old June 16th, 2004, 06:20 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Those are again structural changes. Having replication set up on both the DB servers, it can get sync with. But got to be careful in leaving anything incomplete on the development db, so that it doesn't affect the live one.

Cheers!

_________________________
-Vijay G
Strive for Perfection
  #5 (permalink)  
Old June 17th, 2004, 11:11 PM
Authorized User
 
Join Date: Jun 2003
Location: , , Romania.
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
Default

happygv,

you can use replication to replicate STRUCTURAL changes?
  #6 (permalink)  
Old June 18th, 2004, 01:28 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Yes defiant,

With the help of MERGE replication. If I am not wrong.

Cheers!

_________________________
-Vijay G
Strive for Perfection


Similar Threads
Thread Thread Starter Forum Replies Last Post
free web hosting for Classic ASP and a MySQL DB crmpicco Classic ASP Basics 1 March 14th, 2007 06:00 AM
hosting for PHP and PGSQL DB crmpicco Beginning PHP 0 February 5th, 2007 09:52 AM
ASP.NET 2.0 & SQL Server 2000 / 2005 Hosting NonStopMark ASP.NET 2.0 Basics 1 January 1st, 2007 02:56 AM
Making changes to DB on hosting server w/ VS.NET ltdanp21 VS.NET 2002/2003 1 June 15th, 2004 03:55 PM
making a db field link on a page doranaz Classic ASP Databases 0 December 19th, 2003 01:13 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.