Forum for users of SQL Compare schema synchronization utility


Postby mj_developer » Wed Oct 26, 2011 9:42 am

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.
Posts: 1
Joined: Wed Oct 26, 2011 8:47 am

Postby eddie davis » Thu Oct 27, 2011 3:39 pm


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 Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1146
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest