Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Query to synchronize two Databases Expand / Collapse
Author
Message
Posted Wednesday, November 4, 2009 5:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 22, 2009 10:47 PM
Points: 5, Visits: 49
Hi friends,

Presently in order to synchronize two databases w.r.t tables, columns and constraints we use a tool. I was wondering is it possible to have a query to compare the schema of two different dbs keeping one as master and the other as slave and all those master tables that are not in slave should be pointed out and if possible the query should make a DDL for such a table with Create or Alter depending upon their existence and differences.


Thanks.
Regards,
Waqas.
Post #813530
Posted Thursday, November 5, 2009 7:52 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 4:24 AM
Points: 685, Visits: 104
Probably not answer you are expecting but you can try red gate sql data compare, http://www.red-gate.com/products/SQL_Data_Compare/index.htm

It should be able to generate the scripts for you.



Everything you can imagine is real.

Post #814248
Posted Thursday, November 5, 2009 8:49 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, October 31, 2011 1:10 PM
Points: 480, Visits: 1,163
What tool do you presently use for DB schema comparison?

--
Post #814322
Posted Thursday, November 5, 2009 10:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 22, 2009 10:47 PM
Points: 5, Visits: 49
we use ' SQL execMS '
http://www.laplas-soft.com/

Regards,
Waqas
Post #814706
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse