Red Gate forums :: View topic - BUG:Database to Script Folder synch overwriting partitioning
Return to www.red-gate.com RSS Feed Available

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

BUG:Database to Script Folder synch overwriting partitioning

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
aborecki



Joined: 17 Oct 2011
Posts: 1

PostPosted: Mon Oct 17, 2011 10:51 am    Post subject: BUG:Database to Script Folder synch overwriting partitioning Reply with quote

Hello,
I have noticed following bug when synchronizing scripts directory with database as source.
To reproduce:
1) Create empty database
2) Create table.
3) Add partitioning info to the table.
4) Use SQL Compare to synchronize database to some empty folder with
option "Ignore filegroups, partitions schemes and partition functions" NOT checked.
Now we have table DDL with partitioning information added.
6) Drop partitioning from the table.
7) Synchronize database to scripts directory but now with "Ignore filegroups etc" checked.
8 ) Check DDL file for the table. Partitioning information is missing. It was overwritten. It should not be overwritten as option "Ignore filegroups, partitions schemes ..." was checked.

IMHO the behaviour in this case should be identical to database2database synchronization, when only ALTER's are generated by the tool, information which is set to be ignored on the options screen is really ignored not overwritten.

Issue exists in SQL Compare 9.0 (the latest version) and also in version 9.5 EA.
Back to top
View user's profile Send private message
Chris.Allen



Joined: 12 Mar 2009
Posts: 594

PostPosted: Wed Oct 19, 2011 5:32 pm    Post subject: Reply with quote

Sorry- I'm not entirely clear why you are dropping at point 6? It looks like you might have missed off point 5?
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