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
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