compare only indexes/keys

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

compare only indexes/keys

Postby mryhmln » Wed Aug 15, 2012 3:39 pm

I would really like to have a way of separating table scripts from foreign key/index creation scripts. Currently, we have replication set up on a number of tables in our database and our reinitialization process for replication is to drop all tables, regenerate all of the tables through replication, and then run a "post script" to reapply all of the indexes/views on the tables. Currently I will run sql compare to generate a script that includes all of the table and foreign/key index scripts, and then manually break out the index/foreign key scripts. it would be helpful if sql compare could help with this so it's less of a manual process, e.g. offering an option to compare keys/indexes only as opposed to ignoring them.
Posts: 12
Joined: Mon Aug 29, 2011 4:05 pm

Return to SQL Compare 10

Who is online

Users browsing this forum: Bing [Bot] and 0 guests