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 did a sql compare and the generated script has an ALTER sp before the ALTER table where I had added a new column.
So I have to manually modify the script to put the ALTER table before the ALTER sp.
Did I miss something during the script generation?
- Posts: 1
- Joined: Tue Sep 11, 2012 4:25 pm
What build of SQL Compare are you running? You could try the following under the "options" tab in the project setup:
- Add object existence checks
- Force Column order
Red Gate Software Ltd.
- Posts: 84
- Joined: Mon Apr 23, 2012 1:13 pm
Return to SQL Compare 10
Who is online
Users browsing this forum: No registered users and 0 guests