Comments
Sort by recent activity
Hi @JSommers,
Unfortunately, SQL Compare 10.7 does not support SQL Server 2016. I don't believe we have strong restrictions in place inside the product to prevent you to do this and fail early in the process but expect it to fail on certain cases where it cannot understand SQL Server 2016 engine specifics which should be a lot.
I suggest you to upgrade to SQL Compare 12 which will support your use case. Feel free to download the trial version and try this out. / comments
Hi @JSommers,
Unfortunately, SQL Compare 10.7 does not support SQL Server 2016. I don't believe we have strong restrictions in place inside the product to prevent you to do this and fail early in t...
Hi @brij_singh555,
You should be able to load a SQL Compare snapshot into a C# Database object like below and the rest should be the same as comparing database to database really. using (Database snapshot = new Database())
{
// Load the database schema previously stored as the snapshot
var snapshotFile = Path.Combine(Directory.GetCurrentDirectory(), "mysnapshot.snp");
snapshot.LoadFromDisk(snapshotFile);
}
Hope this answers your question but do let us know if you have more questions [image] / comments
Hi @brij_singh555,
You should be able to load a SQL Compare snapshot into a C# Database object like below and the rest should be the same as comparing database to database really.using (Database sn...
Hi @Jack_Fang,
Which exact version of of Data Compare are you on? We have previously fixed a bug related to this which has been released as part of v11.4.5. So, if you are on an older release than that, upgrading to this or a later one might fix your issue.
Tugberk / comments
Hi @Jack_Fang,
Which exact version of of Data Compare are you on? We have previously fixed a bug related to this which has been released as part of v11.4.5. So, if you are on an older release than ...
Hi jstrate,
I've looked for a way to do this outside of services but can't find any other place to do so.
We don't have a way to change the credentials of a SQL Clone Agent service inside the product itself. Services section on Windows would be the best place to do this.
Unfortunately, when we do this the agent gets disconnected and will not reconnect.
This could happen if the new log on credentials given to the SQL Clone Agent service doesn't have Local admin privileges. Please check "SQL Clone Agent requirements" section inside our docs to make sure that the log on user has the necessary permissions. / comments
Hi jstrate,
I've looked for a way to do this outside of services but can't find any other place to do so.
We don't have a way to change the credentials of a SQL Clone Agent service inside the pr...
Hi wonderbison,
Another feature that would be good is the ability to locally install SQL Server.
Could you give us more information about this, especially around how you see this working within the context of SQL Clone (e.g. during cloning process, etc.)? I doubt that we will be able to do this but would be great to understand a bit more. / comments
Hi wonderbison,
Another feature that would be good is the ability to locally install SQL Server.
Could you give us more information about this, especially around how you see this working within ...
Hey adambaldwin,
I am following up on this now to see why this is happening. I will come back to you shortly. / comments
Hey adambaldwin,
I am following up on this now to see why this is happening. I will come back to you shortly.
Hi Adam,
Sorry for the wait. The issue you are seeing has been fixed with the latest version of SQL Compare but we haven't released a DLM Automation Suite version which has that version of SQL Compare. In the meantime, we are trying to figure out when we can release that. I will be in touch when we know more.
Tugberk / comments
Hi Adam,
Sorry for the wait. The issue you are seeing has been fixed with the latest version of SQL Compare but we haven't released a DLM Automation Suite version which has that version of SQL Comp...
Hey Adam,
Can you upgrade to the latest version of DLM Automation Suite (which is 1.3.11.393)? The problem you are seeing should be resolved in this release. You can download the latest release here: https://www.red-gate.com/dynamic/produc ... e/download
Let us know if you still have the problem after the upgrade.
Tugberk / comments
Hey Adam,
Can you upgrade to the latest version of DLM Automation Suite (which is 1.3.11.393)? The problem you are seeing should be resolved in this release. You can download the latest release her...
Hey swinghouse,
Specifying the username and password through the Octopus Deploy variables like you indicated should work fine for SQL Release step templates. I have just double checked it and it appears to be working. Couple of things that comes to my mind:
- make sure that you are typing the password correct under the variables page.
- make sure that your variable has been scoped correctly. See this for more info: http://docs.octopusdeploy.com/display/O ... +variables / comments
Hey swinghouse,
Specifying the username and password through the Octopus Deploy variables like you indicated should work fine for SQL Release step templates. I have just double checked it and it ap...
Hi AsafC,
With the SQL Release v1.2.1.2809 (which you can get with the DLM Automation Suite v1.2.0.2562: http://documentation.red-gate.com/displ ... e10th,2015), Changes.html now shows you the Static data changes. You can find the full release notes here: http://documentation.red-gate.com/displ ... e10th,2015
Also, you will see that we have a completely new changes report and we are working on improving it. You can find more information on this here: http://documentation.red-gate.com/displ ... ne3rd,2015
Let us know if you have any further questions and hope you will like the new report [image] / comments
Hi AsafC,
With the SQL Release v1.2.1.2809 (which you can get with the DLM Automation Suite v1.2.0.2562: http://documentation.red-gate.com/displ ... e10th,2015), Changes.html now shows you the Sta...