Multiple databases + system generated constraint names...

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

Multiple databases + system generated constraint names...

Postby UKRoyster » Fri Jan 25, 2013 9:40 am

Hi there,

I have multiple Azure databases all with same schema version, however they do have different system-generated constraint names.

1. Do I need to prepare an upgrade script for each database or is one upgrade script ok? I know there is option to ignore system named constraints and index names.
2. By ignoring option, will i run into any risk across the multiple databases?

Thanks for your time,
Roy.
UKRoyster
 
Posts: 6
Joined: Fri Jan 25, 2013 9:24 am

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests