| Author |
Message |
aborecki
Joined: 17 Oct 2011 Posts: 1
|
Posted: Mon Oct 17, 2011 10:51 am Post subject: BUG:Database to Script Folder synch overwriting partitioning |
|
|
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 |
|
 |
Chris.Allen
Joined: 12 Mar 2009 Posts: 442
|
Posted: Wed Oct 19, 2011 5:32 pm Post subject: |
|
|
| 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 |
|
 |
|
|
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