Comments
Sort by recent activity
Hello,
With SQL Doc, unfortunately, you cannot include maintenance plans as they are stored outside of the DB in SQL Server and SQL Doc is built to document the object that exist in the database. / comments
Hello,
With SQL Doc, unfortunately, you cannot include maintenance plans as they are stored outside of the DB in SQL Server and SQL Doc is built to document the object that exist in the database.
Hello,
We've opened up a ticket for this support issue so we can gather more information on your issue and troubleshoot further and quicker then a forum would let us. Please look for that email and get back to me, thanks. / comments
Hello,
We've opened up a ticket for this support issue so we can gather more information on your issue and troubleshoot further and quicker then a forum would let us. Please look for that email and...
Hello Jansen,
The automatic mapping cannot be disabled but your workflow can be achieved in the following steps:
1. Map the tables and columns how you need them manually
2. Save the project which will include the custom mappings
3. Always load the project with the manual mappings when working on this
Below are some links to documentation on these steps: http://documentation.red-gate.com/displ ... nd+columns http://documentation.red-gate.com/displ ... h+projects / comments
Hello Jansen,
The automatic mapping cannot be disabled but your workflow can be achieved in the following steps:
1. Map the tables and columns how you need them manually
2. Save the project which w...
Hello,
With SQL Compare command line you could script out compares you want to perform and then use some way to kick them off on a schedule. There are no built in scheduling tools to SQL Compare or SQL Source Control. / comments
Hello,
With SQL Compare command line you could script out compares you want to perform and then use some way to kick them off on a schedule. There are no built in scheduling tools to SQL Compare or...
Hello John,
I believe we looked at this issue and you got it resolved when your DBA added scripting permissions to the restricted DB. Let me know if you have any other questions, thanks. / comments
Hello John,
I believe we looked at this issue and you got it resolved when your DBA added scripting permissions to the restricted DB. Let me know if you have any other questions, thanks.
Hello,
DB, instance, and server settings are not objects or data of the DB so they are not compared by SQL Compare and SQL Data Compare. These two products compare the schema objects and the data in those objects to each other. / comments
Hello,
DB, instance, and server settings are not objects or data of the DB so they are not compared by SQL Compare and SQL Data Compare. These two products compare the schema objects and the data i...
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.