Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to update a database structure?
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01524837
Message ID:
01524843
Views:
44
>>>>>Hi,
>>>>>
>>>>>How do you update a database structure (default keys, constraint, etc) installed on the customer site with the changes you have made to your copy of SQL Server database? That is, I understand that I have to create some script and send it to the customer and instruct them to run this script, correct? How do you create such a script? TIA.
>>>>
>>>>We're using RedGate SQLCompare.
>>>
>>>Is this a commercial product? If so, is there a way to do it without buying a tool for that?
>>
>>Yes, it's a commercial produce. I recommend to review this thread Compare SQL Tools Thread #1419284 Message #1419284, I believe there are some free tools mentioned there as well.
>
>Thank you.

I was just going to add this also
http://msdn.microsoft.com/en-us/library/ff678491.aspx

as another alternative.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform