Comments
Sort by recent activity
@Joklbash Thanks for confirming. I'll let you know once there is further update regarding this issue (SP-7650). So sorry for the inconvenience caused. / comments
@Joklbash Thanks for confirming. I'll let you know once there is further update regarding this issue (SP-7650). So sorry for the inconvenience caused.
@Joklbash Are you on the latest version of SQL Prompt? If so this is a different bug which we've logged as SP-7650. @ahdung Sorry for hitting this bug SP-7650. I'll keep you both posted once I have more information. / comments
@Joklbash Are you on the latest version of SQL Prompt? If so this is a different bug which we've logged as SP-7650. @ahdung Sorry for hitting this bug SP-7650. I'll keep you both posted once I have...
Thanks for posting. It was a known bug which has been fixed in the later release (5.5.6.5519). I'm not sure why you are hitting this issue as you are on much newer version. A ticket has been created for you in this case and we'll have a look together. Thanks! / comments
Thanks for posting. It was a known bug which has been fixed in the later release (5.5.6.5519). I'm not sure why you are hitting this issue as you are on much newer version. A ticket has been create...
Unfortunately SQL Source Control is prone to out of memory errors for very large operations due to SSMS limitations. We would recommend linking to a working folder instead when dealing with a large repository. / comments
Unfortunately SQL Source Control is prone to out of memory errors for very large operations due to SSMS limitations. We would recommend linking to a working folder instead when dealing with a large...
Hi, thanks for getting in touch! We've made a support ticket for this so you will be contacted shortly. / comments
Hi, thanks for getting in touch! We've made a support ticket for this so you will be contacted shortly.
I'm sorry to say it's a known issue where DLM Dashboard incorrectly detects differences because sub-objects in the two databases are being scripted in different orders. However, we have not been able to prioritize it for bug fixing. / comments
I'm sorry to say it's a known issue where DLM Dashboard incorrectly detects differences because sub-objects in the two databases are being scripted in different orders. However, we have not been ab...
Hi,
First of all, can I suggest you to upgrade your SQL Compare to the latest version?
By default, SQL Compare deploys the change with Migration scripts only from SQL Source Control or Script folder.
To do this using command line, for example if the source is from SQL Source Control, you need to:
1- create '/ScriptsFolderXML:<file path>' - The path to a text file containing XML that describes the location of a source control repository.
Please check this link for how to create it: https://documentation.red-gate.com/display/SC13/Switches+used+in+the+command+line#Switchesusedinthecommandline-/ScriptsFolderXML
2- run the command line like:
sqlcompare /sourcecontrol1 /revision1:4 /sfx:"D:\DB\test.xml" /db2:talkr_prod /s2:DEV-USER1\SQLSERVER2016 /sync
More details about the '/Sourcecontrol1' switch can be found here: https://documentation.red-gate.com/display/SC13/Switches+used+in+the+command+line#Switchesusedinthecommandline-/Sourcecontrol1
If you want to ignore the migration script using command line, check this link for more details: https://documentation.red-gate.com/display/SC13/Options+used+in+the+command+line#Optionsusedinthecommandline-IgnoreMigrationScripts
Thanks. / comments
Hi,
First of all, can I suggest you to upgrade your SQL Compare to the latest version?
By default, SQL Compare deploys the change with Migration scripts only from SQL Source Control or Script folde...
Hi @Sindre When you install SQL Data Compare, you will be asked to install it to which directory: [image] Hope this helps. / comments
Hi @Sindre When you install SQL Data Compare, you will be asked to install it to which directory:Hope this helps.
Hi ckaeser ,
At present you can achieve this by going into comparison results and for each table selecting the columns manually.
If you wish to have this automated, can you please kindly leave a suggestion on our user voice forum so that other people can vote for it. / comments
Hi ckaeser ,
At present you can achieve this by going into comparison results and for each table selecting the columns manually.
If you wish to have this automated, can you please kindly leave a su...
Hi AdrianZ As decrypt encrypted objects can impact the performance of SQL Compare, please uncheck that option if it's not needed. https://documentation.red-gate.com/sc13/troubleshooting/common-issues/comparison-seems-slow / comments
Hi AdrianZ As decrypt encrypted objects can impact the performance of SQL Compare, please uncheck that option if it's not needed.https://documentation.red-gate.com/sc13/troubleshooting/common-issue...