Comments
Sort by recent activity
When Data Compare launches, it tries to find servers on the local network to fill in the list. However, you can just type in the address of any new servers that you want to use, and Data Compare should remember them for next time [image] / comments
When Data Compare launches, it tries to find servers on the local network to fill in the list. However, you can just type in the address of any new servers that you want to use, and Data Compare sh...
You might be able to use the WHERE clause filter to do what you want: https://documentation.red-gate.com/disp ... ERE+clause / comments
You might be able to use the WHERE clause filter to do what you want: https://documentation.red-gate.com/disp ... ERE+clause
Hi,
When using the command line, you'll need to set options using the /Options switch instead of a ComparisonOptions.xml file (I believe the latter is only used by SQL Source Control)
This page has more details: http://documentation.red-gate.com/displ ... mmand+line - hope it's helpful / comments
Hi,
When using the command line, you'll need to set options using the /Options switch instead of a ComparisonOptions.xml file (I believe the latter is only used by SQL Source Control)
This page has...
Hi there,
I've asked around a bit and it looks like this is due to how SQL Source Control is implemented. SQL Source Control uses SQL Compare under the hood, and when it wants to delete a file it wants to use the version control system (VCS) API to do it rather than having Compare delete the file, because of edge cases in some VCS implementations. Unfortunately this means that when SQL Compare deploys to a scripts folder normally, it ends up emptying the file instead of deleting it. / comments
Hi there,
I've asked around a bit and it looks like this is due to how SQL Source Control is implemented. SQL Source Control uses SQL Compare under the hood, and when it wants to delete a file it w...
If you add a DEFAULT value to the create_dt column in dev, then Compare should fix null values using that default before applying the NOT NULL constraint. Does that help? / comments
If you add a DEFAULT value to the create_dt column in dev, then Compare should fix null values using that default before applying the NOT NULL constraint. Does that help?
Sorry for the confusion - in this context 'snapshot' refers to a SQL Compare snapshot file, which is schema-only and should be a lot smaller than 40GB. Support would be able to help you find a minimal reproduction, although I totally understand if you don't have the time to go through that process. I don't think we currently have any way to reproduce the issue over here, but we can keep an eye out and see if something pops up. / comments
Sorry for the confusion - in this context 'snapshot' refers to a SQL Compare snapshot file, which is schema-only and should be a lot smaller than 40GB. Support would be able to help you find a mini...
Unfortunately I don't think this is possible at the moment. However, it is an item on our backlog (SC-4469 - Allow Windows Authentication with specified credentials)
I'm assuming the UI you'd want is just a place to type in an alternate windows username/password -- does that sound right? / comments
Unfortunately I don't think this is possible at the moment. However, it is an item on our backlog (SC-4469 - Allow Windows Authentication with specified credentials)
I'm assuming the UI you'd want ...
Is there a specific part of the deployment script formatting that you're having trouble with? There isn't a general behave-like-Compare-10 option, but it might be possible to work around the problem. / comments
Is there a specific part of the deployment script formatting that you're having trouble with? There isn't a general behave-like-Compare-10 option, but it might be possible to work around the problem.
Ah, I see. I think the dropdown is supposed to remember previous folders that you've visited, but it looks like it might remove items from the most-recently-used list if it doesn't think the folders are invalid or don't exist - maybe the network directories are confusing it. / comments
Ah, I see. I think the dropdown is supposed to remember previous folders that you've visited, but it looks like it might remove items from the most-recently-used list if it doesn't think the folder...
Hi there
If I'm understanding you correctly, there's a little browse button to the right of the dropdown (labelled [...]) that lets you change the folder to look in. Does this do what you want? / comments
Hi there
If I'm understanding you correctly, there's a little browse button to the right of the dropdown (labelled [...]) that lets you change the folder to look in. Does this do what you want?