Red Gate forums :: View topic - synchronization
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

synchronization

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
mj_developer



Joined: 26 Oct 2011
Posts: 1

PostPosted: Wed Oct 26, 2011 10:42 am    Post subject: synchronization Reply with quote

I have an important question.

I've hosted my website on a web server. After a few weeks I've made some changes on the database of this website in my local computer and now I want to upgrade the database that is currently hosted on the web server to the new database with keeping the previous data in the privous database. How can I do this without causing any problem for the database that is on the web server?

Thanks a million.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Thu Oct 27, 2011 4:39 pm    Post subject: Reply with quote

Hi

Thank you for your post into the forum.

Before you update and make changes to the website database, I recommend that you backup this database and then restore a copy of it to a test machine.

Next compare the database on your local computer with the copy of the website database on the test machine. Followed by syncronization and observe what occurs.

When you perform the comparison you will be informed of the following:

Objects that exist only in the local computer.
Objects that exist in both data sources but are different.
Objects that exist only in the Website database.
Objects that are identical.

When you synchronize (in the direction of local database to website database) by default, dependent upon the object you have included in the synchronization, SQL Compare will:

    1. Objects that exist only in the local computer, will be created in the website database. This will incur no data loss as new objects are being created.

    2. Objects that exist in both data sources but are different, the objects in the website database will be altered to match the local database. This may incur data loss, as existing table columns may be dropped or deleted and the data held in these columns will be lost.

    3. Objects that exist only in the Website database, these objects will be dropped. This will result in data loss.


When you review the comparison results only select the individual objects you wish to synchronize.

But I can only stress that you should test before moving to your live website database. Also backup the live website database immediatley before synchronizing the database, this will allow you to recover back / restore to the same database state before you run the synchronization process.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group