Comments
Sort by recent activity
Hello,
If the issue is with SQL Data Compare and it's trying to insert 'null' values from source where the target does not allow it then there is no fix SQL Data Compare can do as tSQL is preventing the illegal transaction. The schema would need to be updated to allow nulls or the nulls removed from the source. / comments
Hello,
If the issue is with SQL Data Compare and it's trying to insert 'null' values from source where the target does not allow it then there is no fix SQL Data Compare can do as tSQL is preventin...
Hello,
For preserving the metadata the best way I can think of would be to create a separate DB for logging changes and moving that over as well when you do the image restore, along with any relevant configuration files. There isn't really a way built into SQL Source Control for this use case so there will be some charting of unknown waters on this type of environment but it should be doable to move the data over. http://documentation.red-gate.com/displ ... by+Unknown http://documentation.red-gate.com/displ ... +databases / comments
Hello,
For preserving the metadata the best way I can think of would be to create a separate DB for logging changes and moving that over as well when you do the image restore, along with any releva...
Hello,
Thanks for your questions on SQL Source Control and DLM (database lifecycle management). Your questions and environment needs are more complex than what can be answered through a ticket/forum post but we do have a team of people who work on these types of issues and work with enterprise environments. They can be reached at dlm@red-gate.com. I would recommend reaching out to them and arranging some time to go over your questions and unique environment needs. / comments
Hello,
Thanks for your questions on SQL Source Control and DLM (database lifecycle management). Your questions and environment needs are more complex than what can be answered through a ticket/foru...
Hello Scott,
You are correct you would need to install Git and have your repository system setup before using SQL Source Control to link to it. / comments
Hello Scott,
You are correct you would need to install Git and have your repository system setup before using SQL Source Control to link to it.
Hello,
The best way to do this work would be with SQL Compare/Data Compare. In the GUI version create your project file pointing at your TFS repository. Then save that project and use it in the command line interface (CLI) for SQL Compare/Data Compare. This will allow you to script it out and automate this workflow. From this point you can setup as many of these as you need for your environments and change sets. / comments
Hello,
The best way to do this work would be with SQL Compare/Data Compare. In the GUI version create your project file pointing at your TFS repository. Then save that project and use it in the com...
Hello Matthew,
There is a way to change the timeout, it is done by setting the CommandTimeout. I found this information on this error and setting: http://www.codeproject.com/Questions/49 ... tplusperio
Let me know if you need anything else, thanks. / comments
Hello Matthew,
There is a way to change the timeout, it is done by setting the CommandTimeout. I found this information on this error and setting: http://www.codeproject.com/Questions/49 ... tplusp...
Hello,
SQL Compare and SQL Data Compare are meant for deployments to match up a target with a source. So with this terminology (source and target) you would not merge differences, you would deploy from source and remove from target to bring both to the same Schema/Data.
If you are in a situation where Dev A is working on one copy and Dev B is working on another copy of a database and you may need to merge both changes together that is source controlling your database. Our product SQL Source Control can handle that and has options to merge two changes made by separate developers like the example you describe. / comments
Hello,
SQL Compare and SQL Data Compare are meant for deployments to match up a target with a source. So with this terminology (source and target) you would not merge differences, you would deploy ...
Hello Chuck,
The easiest way to do this is on the result page select a smaller number of changes to deploy, do a re-compare after deploy and pick the rest or the next third or whatever percentage of changes works for your environment. This basically creates several partial deployments and you can control what each one contains.
Let me know if you need anything else, thanks. / comments
Hello Chuck,
The easiest way to do this is on the result page select a smaller number of changes to deploy, do a re-compare after deploy and pick the rest or the next third or whatever percentage o...
Hello Jason,
Below is the documentation on what is needed in the licenses.licx file, it looks like you may be missing some dependencies: http://documentation.red-gate.com/displ ... arison+SDK / comments
Hello Jason,
Below is the documentation on what is needed in the licenses.licx file, it looks like you may be missing some dependencies:http://documentation.red-gate.com/displ ... arison+SDK
Hello Branko,
This issue has been recorded as a bug in JIRA # SC-7719. The deployment script generated does not actually make any changes just the results page is displaying incorrectly. I will let you know of updates to the bug and an ETA on a fix when one is available, thanks. / comments
Hello Branko,
This issue has been recorded as a bug in JIRA # SC-7719. The deployment script generated does not actually make any changes just the results page is displaying incorrectly. I will let...