Red Gate forums :: View topic - New columns appended to table i.e. not in designed order
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

New columns appended to table i.e. not in designed order

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



Joined: 27 Apr 2012
Posts: 3

PostPosted: Fri Apr 27, 2012 2:52 pm    Post subject: New columns appended to table i.e. not in designed order Reply with quote

I noticed after using the deployment wizard that new columns that I had added to a table had been copied across OK but not in the deliberate order I had placed them in, in the original table.
This will have no material affect on functionality (unless someone sorts or groups by column number directly against the table) but for design reasons we group columns together according to their functionality. I'm sure most DB designers do this and I very much feel that your application should not be overriding this decision.

Regards

Derek Robinson
SQL Compare v 10.1.0.102
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Mon Apr 30, 2012 2:41 pm    Post subject: Reply with quote

Hi Derek

Thank you for your forum post.

Have you tried setting the SQL Compare option "Force column order" in your SQL Compare project?

If the answer is no, can you please Edit Project ->Options tab ->Behavior section ->Enable the "Force column order". Hopefully this action will keep the column order you deliberately set.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
DerekR



Joined: 27 Apr 2012
Posts: 3

PostPosted: Mon Apr 30, 2012 6:00 pm    Post subject: Yup Reply with quote

Thanks Eddie, that was it. Thanks for the speedy reply to this.
I'm very suprised that this option is unticked by default.
Personally, if I take the time to place a column in relation to its function and related columns then I want this metadata to be carried through by SQL-Compare. I can't think of a situation when I wouldn't.
Additionally, if I had code which used ordinal column numbers for sort or grouping criteria then SQL Compare would actually break the application by possibly returning the results in the wrong order and it would be very difficult to trace as it would be non-reproducible at source.
Please pass these comments on to the development team at RedGate.

Regards

Derek
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Tue May 01, 2012 3:26 pm    Post subject: Reply with quote

Hi Derek,
Thank you for your reply.

I will feed back your comments onto the Development team.

However I believe this option is not enabled by default, as the "Force column order" will force a table rebuild to preserve any existing data in the target table.

By not having to force a table rebuild, will improve the performance of the deployment process.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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