Red Gate forums :: View topic - ALTER sp before ALTER table
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

ALTER sp before ALTER table

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nvman_ca



Joined: 11 Sep 2012
Posts: 1

PostPosted: Tue Sep 11, 2012 4:30 pm    Post subject: ALTER sp before ALTER table Reply with quote

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?

Thanks,
Aaron
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 72

PostPosted: Thu Sep 13, 2012 10:36 pm    Post subject: Reply with quote

Hi nvman_ca,

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

Best Regards,
Steve
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group