Comments
Sort by recent activity
@DavidStein
> I am consistently getting this error in the latest version of SQL Compare (13.1.1.5299) and I'd really like to know why.
Could you tell me what version of Windows are you using? / comments
@DavidStein
> I am consistently getting this error in the latest version of SQL Compare (13.1.1.5299) and I'd really like to know why.
Could you tell me what version of Windows are you using?
Thanks all for getting back to us, it's really encouraging to see the positive response which ensures us that we are on the right path here [image]
We plan to have a way to exclude identical objects from the report just like you can do today. @TheSQLGuru Thanks for the other suggestions, really useful to know. May I ask why order and search will be useful for you use case? Also, even if it's not entirely what you are asking, you could expand all and use the browser search capability to search with the new report format. / comments
Thanks all for getting back to us, it's really encouraging to see the positive response which ensures us that we are on the right path here
We plan to have a way to exclude identical objects from ...
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...