BUG:Database to Script Folder synch overwriting partitioning

Forum for users of SQL Compare schema synchronization utility

BUG:Database to Script Folder synch overwriting partitioning

Postby aborecki » Mon Oct 17, 2011 9:51 am

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.
Posts: 1
Joined: Mon Oct 17, 2011 9:33 am

Postby Chris.Allen » Wed Oct 19, 2011 4:32 pm

Sorry- I'm not entirely clear why you are dropping at point 6? It looks like you might have missed off point 5?
Posts: 579
Joined: Thu Mar 12, 2009 3:17 pm

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests