Comments
Sort by recent activity
Hey km,
Thanks for contacting us!
If you are using the SQL Statement Generic generator it is just writing a Select statement against the target database- so i'm not sure how you would write a script that was general enough to be used in multiple columns where you need the target tablename to be different - you cannot pass the target table.
Also note that this tool is used for mixing up and generating data - it does not do a great job of just altering a specific subset of data - if you choose a table to generate into - it will delete everything within it and insert a bunch of mixed up/generated data.
I hope that helps! / comments
Hey km,
Thanks for contacting us!
If you are using the SQL Statement Generic generator it is just writing a Select statement against the target database- so i'm not sure how you would write a scrip...
Hey etabelev,
Thanks for contacting us!
Can you just confirm that the remote server is a Microsoft SQL Server Instance and not a MySQL instance?
Can you send in the full step log?
Are you having issues with the Build step as well?
Is that user configured in the remote sql server instance and what permissions does it have?
Thanks! / comments
Hey etabelev,
Thanks for contacting us!
Can you just confirm that the remote server is a Microsoft SQL Server Instance and not a MySQL instance?
Can you send in the full step log?
Are you having is...
Thanks for contacting us and that is odd!
Perhaps if you uninstall v5 and delete the Source Control v5 appdata folder (that countains the transients and such) - then upgrade to v4 - then upgrade to v5.
Here us a link to v4 ftp://support.red-gate.com/patches/sqlsourcecontrol/19Apr2016/SQLSourceControl_4.4.0.1714.exe
I hope that helps! / comments
Thanks for contacting us and that is odd!
Perhaps if you uninstall v5 and delete the Source Control v5 appdata folder (that countains the transients and such) - then upgrade to v4 - then upgrade to...
Hey dlaws2,
Thanks for contacting us!
Typically users put the app code in a folder parallel to the db code folder within the repository - that way the versioning is done in such a way that it will give you a good idea about what changes (app and db) were made around the same period and under the same version.
You would need to deploy app changes to your QA/UAT environments using CI software such as TFS/TeamCity/Bamboo/Jenkins and then to prod using a release management software such as Octopus Deploy/TFS/Bamboo - so essentially you can do it parallel to your db code but just in an app pipeline instead of a db pipeline.
Personally I really like using TeamCity and Octopus Deploy together - that should be a decent start guide for automating app deployments.
some various documentation below: https://octopus.com/docs/getting-started https://octopus.com/docs/api-and-integration/teamcity https://confluence.jetbrains.com/display/TCD10/Continuous+Integration+with+TeamCity https://blog.jetbrains.com/teamcity/2015/11/automating-deployments-with-teamcity-and-octopus-deploy/ https://confluence.jetbrains.com/display/TCD10/Continuous+Integration+with+TeamCity / comments
Hey dlaws2,
Thanks for contacting us!
Typically users put the app code in a folder parallel to the db code folder within the repository - that way the versioning is done in such a way that it will ...
Thanks for contacting us!
It should work in v5.5.2 and later
Do let me know if you have any issues with that!
Warmly, / comments
Thanks for contacting us!
It should work in v5.5.2 and later
Do let me know if you have any issues with that!
Warmly,
Hey gvsoft,
Thanks for contacting us!
This is actually an option in SQL Compare currently - see the "Add object existence checks" option here https://documentation.red-gate.com/display/SC12/Setting+project+options
or here for the command line. https://documentation.red-gate.com/display/SC12/Options+used+in+the+command+line#Optionsusedinthecommandline-ObjectExistenceChecks
Warm Regards, / comments
Hey gvsoft,
Thanks for contacting us!
This is actually an option in SQL Compare currently - see the "Add object existence checks" option herehttps://documentation.red-gate.com/display/SC12/Setting+...
Hey dnelson3,
Thanks for contacting us and sorry you are having this issue!
It looks like you cannot do table filtering right now (because you cannot get to Tables and Views) so you might need to change the location of the temporary files to an attached 1tb hard drive (usb or regular Sata - whatever works for you). https://documentation.red-gate.com/display/SDC12/Improving+the+performance+of+SQL+Data+Compare
Also you can turn on logging and send in the log file, we might be able to figure out where or why it is hanging. https://documentation.red-gate.com/display/SDC12/Logging+and+log+files
Thanks! / comments
Hey dnelson3,
Thanks for contacting us and sorry you are having this issue!
It looks like you cannot do table filtering right now (because you cannot get to Tables and Views) so you might need to c...
Hey Raj,
Thanks for contacting us and sorry you are having this issue!
This bug was fixed in the Red Gate Team City plugin v4.0.3.93 that was released today http://www.red-gate.com/products/dlm/dlm-automation/add-ons-simple
Do let me know if you have any issues with that!
Warmly, / comments
Hey Raj,
Thanks for contacting us and sorry you are having this issue!
This bug was fixed in the Red Gate Team City plugin v4.0.3.93 that was released today http://www.red-gate.com/products/dlm/dl...
Thanks for contacting us!
This error makes sense, because if both windows were working on the same database then there would be potential conflicts between the two repository and database readers.
However, you can enable Source Control in multiple SSMS windows on the "Setup" tab under "Global options"
Do let me know if you have any questions or issues with that!
Warmly, / comments
Thanks for contacting us!
This error makes sense, because if both windows were working on the same database then there would be potential conflicts between the two repository and database readers.
...
Just to recap for anyone reading this - we fixed this by going to Owner Mapping and mapping the schemas together, then going to table mapping and mapping the tables together.
Best, / comments
Just to recap for anyone reading this - we fixed this by going to Owner Mapping and mapping the schemas together, then going to table mapping and mapping the tables together.
Best,