Generate Alter script of a table in two diff version.

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi,

IS their any way to generate an alter script of a table, of two different versions.

If we have a table T1 in Database Dv1, an extra column is added in T1 and the database is named as Dv2.

Then i want to generate an alter script of that extra column.

Using SMO,I could generate scripts of the tables but, how can i compare these two tables and generate the alter script.

Do any one have an idea proceed.

Using SQL SERVER 2008 and C#/VB

Posted 13-Aug-12 2:43am

rok_007

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

barneyman · Answer 1 · 2012-08-13T03:28:00

Solution 1

There are 3 easy ways to do it, 2 are free, but require discipline

1. At every 'epoch', dump all the create files, run winmerge, or similar, over them and create the alters manually
2. Mandate that all changes to DB structure are done with alter scripts, and simply collect and coalesce them
3. use something like Redgate's sqlcompare [^]

I'd personally recommend #2 - I have used Sql Compare, and bluntly, it's brilliant, but #2 gives you traceability

Posted 13-Aug-12 3:28am

barneyman

Updated 13-Aug-12 3:31am

v2

Comments

rok_007 14-Aug-12 9:28am

Thank you barneyman for reply..

I could generate Create script, and compare the two version script as Redgate provides.

But my concern is to automate the generation of alter script comparing the two DB versions.

please let me know any possible ways to build it...

barneyman 14-Aug-12 19:11pm

i don't know of a way, apart from Redgate

rok_007 15-Aug-12 8:41am

Thank you barneyman