Forum for users of SQL Compare schema synchronization utility
Moderators: JonathanWatts, Chris Auckland, David Atkinson
i am new in sql compare 6. i have tried it.
Now I have the following question:
Is it possible to (automatically) initialize/set default values to new fields in the updated database.
For example: for numeric fields set default value to zero (0).
Another "problem" is:
One table gets a new (additional) key field. How can I initialize this field, too?
thanks in advance!
- Posts: 1
- Joined: Mon Jul 23, 2007 9:06 am
I'm afraid there isn't currently a way to automatically initialize newly added fields with default values. It's a feature we've been considering adding in future releases, and I'll add this thread to the feature request.
Currently the obvious workaround is to add a default constraint to the field in the source database, but we understand that isn't the best solution if you don't want the field to have a default after the synchronization is complete.
You can also save the synchronization script / ask Compare to load it in Query Analyzer or Management Studio and then edit the script by hand to have a default constraint added and then dropped from the column.
- Posts: 529
- Joined: Mon Oct 30, 2006 12:45 pm
- Location: Red Gate Software
SQL Compare 9.5 with SQL Source Control 3 allows custom scripts that override default behavior. This should allow you to make any modifications you like, such as setting a default value.
http://www.red-gate.com/MessageBoard/vi ... 1312#51312
Red Gate Software
- Posts: 1124
- Joined: Mon Dec 05, 2005 4:54 pm
- Location: Twitter: @dtabase
Return to SQL Compare Previous Versions
Who is online
Users browsing this forum: No registered users and 0 guests