Comments
Sort by recent activity
anyone want's to reply to my question? / comments
anyone want's to reply to my question?
when the sync fails the error is displayed. usually it involves using non deterministic functions which are allowed on sql 2005 but not on 2000. i see the error and fix it. then i refresh the comparison and try running the sync again. until the run is successfull i have to do this a few times and i end up with 10 scripts which only the last one passes and the rest fail at some point. maybe you should add this as an option to sql compare to delete the script if the sync fails. / comments
when the sync fails the error is displayed. usually it involves using non deterministic functions which are allowed on sql 2005 but not on 2000. i see the error and fix it. then i refresh the compa...
further more on this issue, i would like to be able to find all objects that are using a specific column in a specific table / comments
further more on this issue, i would like to be able to find all objects that are using a specific column in a specific table
the online help for v10 says I need the mod files
I tried running with the new activateserial switch but that too did not create the mod file / comments
the online help for v10 says I need the mod files
I tried running with the new activateserial switch but that too did not create the mod file
what is this license? why is the license changed?
I own a pro version (in the sql toolbelt) so I can use the command line in various environments. am I supposed to buy a new license now?! / comments
what is this license? why is the license changed?
I own a pro version (in the sql toolbelt) so I can use the command line in various environments. am I supposed to buy a new license now?!
Please add a feature like the "Server registration" in SSMS. In SSMS, I register the server once and never again have to remember the password.
I have a lot of DB servers I am connecting to and a lot of databases to compare. Instead of opening a project for every pair, I usually use one project and replace one side of the comparison (the other side is a usually a dev db). on some occasions, I need to compare the dev db to a snapshot or to a backup (again still using the same comparison project as before). after comparison to a snapshot If I need to then compare to a live DB I need again to enter the credentials.
I know I am not using sql compare in the way you planned (with comparison projects) but I find my way much easier for my needs.
in short I think a feature like "server registration" would make life easier in usage cases like mine / comments
Please add a feature like the "Server registration" in SSMS. In SSMS, I register the server once and never again have to remember the password.
I have a lot of DB servers I am connecting to and a l...
Posted to uservoice as you recommended. thanks / comments
Posted to uservoice as you recommended. thanks
Jessica R , Thanks for the detailed info. Glad things are at least progressing.
I agree these are two use cases and as such I think deserve two distinct checkboxes in the project options:
"Format synchronization SQL" and "Show formatted difference". In my case I would use both. Currently from time to time I am taking the sync sql generated and format it on the side and run it manually. The problem is that I could have a formatted sql on one side and unformatted sql on the other side which makes it hard to compare. / comments
Jessica R , Thanks for the detailed info. Glad things are at least progressing.
I agree these are two use cases and as such I think deserve two distinct checkboxes in the project options:
"Format s...
6 years later, any news? / comments
6 years later, any news?
thanks. another feature suggestion: add an option to run custom scripts before and/or after a specific object is syncrinized. e.g. after syncronizing the structure of a table i want to run a few sql statements that will insert a few rows of data into the table. / comments
thanks. another feature suggestion: add an option to run custom scripts before and/or after a specific object is syncrinized. e.g. after syncronizing the structure of a table i want to run a few sq...