Comments
Sort by recent activity
Thanks for your post.
There is a project option to ignore constraints and indexes, but they don't get ignored when the database is deployed.
There is an option with SQL Data Compare that forces the constraints to be enabled with NOCHECK. This would mean you could also deploy the constraints, but the existing data won't be validated against the constraint when it gets created. This might be helpful, unless you actually want the constraints to be different. / comments
Thanks for your post.
There is a project option to ignore constraints and indexes, but they don't get ignored when the database is deployed.
There is an option with SQL Data Compare that forces the...
Sorry, I missed your last post.
I think the only way to do it at the moment is manually. So you could checkout the repository locally, then add the other items to another folder, and then update the repository.
You might also be able to add these objects as a custom migration using the new 'migrations' feature of SQL Source Control, but this would be a bit of a workaround rather than the intended use of the feature. / comments
Sorry, I missed your last post.
I think the only way to do it at the moment is manually. So you could checkout the repository locally, then add the other items to another folder, and then update th...
Thanks for your post.
I'm afraid we only support database level objects i the current version.
Feel free to add a suggestion on our uservoice site. If it's popular, it might get added to a future version. / comments
Thanks for your post.
I'm afraid we only support database level objects i the current version.
Feel free to add a suggestion on our uservoice site. If it's popular, it might get added to a future v...
Hi,
I tried this with 10.0.2531.0, and It didn't ask me to save the open queries.
Are you able to try this on another workstation with SSMS and see if the same thing happens? / comments
Hi,
I tried this with 10.0.2531.0, and It didn't ask me to save the open queries.
Are you able to try this on another workstation with SSMS and see if the same thing happens?
Sorry for the delay, I missed your last query.
This doesn't seem to happen for me.
Which version of SSMS are you using? / comments
Sorry for the delay, I missed your last query.
This doesn't seem to happen for me.
Which version of SSMS are you using?
Thanks for your reply.
By default, SQL Compare will ignore 'filegroups, partition schemes and partition functions'.
Do you get the correct result if you turn off this project option? / comments
Thanks for your reply.
By default, SQL Compare will ignore 'filegroups, partition schemes and partition functions'.
Do you get the correct result if you turn off this project option?
Thanks for your post.
The PK shouldn't be recreated unnecessarily. I set up a quick test following your instructions, and only the index was dropped in my test.
Would you be able to post (or send me) the DDL for your source and target table, and I'll see if I can reproduce the problem? / comments
Thanks for your post.
The PK shouldn't be recreated unnecessarily. I set up a quick test following your instructions, and only the index was dropped in my test.
Would you be able to post (or send m...
Thanks for your post.
Try putting your serial number in here, it should tell you if you're entitled to an upgrade. / comments
Thanks for your post.
Try putting your serial number in here, it should tell you if you're entitled to an upgrade.
Sorry you're having trouble with SQL Compare 10.
I'm not aware of any changes that would cause it to take longer to start up.
Do you still have SQL Compare 9 installed as well? If you start them together, does v10 still take much longer to start?
If it takes longer, I would try reinstalling v10 and see if that helps.
Let me know how you get on, as I'll dig a bit deeper if there is definitely a difference. / comments
Sorry you're having trouble with SQL Compare 10.
I'm not aware of any changes that would cause it to take longer to start up.
Do you still have SQL Compare 9 installed as well? If you start them to...
Thanks for your post.
Can you clarify the exact version you're using, as I don't believe this has been reported before?
Is the only difference with the NOCHECK on that table, and that the GUI shows identical, but the CL shows a difference? / comments
Thanks for your post.
Can you clarify the exact version you're using, as I don't believe this has been reported before?
Is the only difference with the NOCHECK on that table, and that the GUI shows...