Comments
Sort by recent activity
Thanks for your post.
In both scenarios, are you connecting to server B using the same account and project options?
Also, what account are you using to connect to the other databases?
It might be worth checking the permissions; we have a kb document to outline the minimum permissions required for SQL Compare: http://www.red-gate.com/supportcenter/C ... 000072.htm / comments
Thanks for your post.
In both scenarios, are you connecting to server B using the same account and project options?
Also, what account are you using to connect to the other databases?
It might be w...
Thanks for your post.
SQL Compare UI and the SQL Compare API do not have a backup before sync' option.
Database.SavetoDisk will enable you to create a snapshot of the schema, but it will not contain any data.
If you want to perform a backup before you do anything using the API, you could use the BackupCommand Methods of the RedGate.BackupReader namespace (see SQL Data Compare API help).
I hope this is helpful. / comments
Thanks for your post.
SQL Compare UI and the SQL Compare API do not have a backup before sync' option.
Database.SavetoDisk will enable you to create a snapshot of the schema, but it will not contai...
Thanks for your post.
The windows group user shouldn't be treated any differently to the Windows user or the sql users. I have done a quick test and using /exclude:user and my windows group was successfully excluded from the script.
The only thing I could think of is that another object is dependant on that windows group, and since include dependencies is one of the default options for a command line task; it will have been included in the script.
If you do not want to automatically include dependencies then you will need to set the options you do want in the command.
Let me know if this helps or not. / comments
Thanks for your post.
The windows group user shouldn't be treated any differently to the Windows user or the sql users. I have done a quick test and using /exclude:user and my windows group was suc...
Sorry that the last suggestion didn't help. I'm at a loss to see why the Windows user would be treated any differently to the other users.
Would you be able to send me a snapshot of the source schema so that I can recreate the problem here?
You can generate a snapshot using the SQL Compare UI - File >> Export a data source.
If you could attach the snapshot to an email and send it to support@red-gate.com I will log a ticket for you. / comments
Sorry that the last suggestion didn't help. I'm at a loss to see why the Windows user would be treated any differently to the other users.
Would you be able to send me a snapshot of the source sche...
To add to this, here is a small code sample to demonstrate Brian's post. (Based on our SQL Compare API sample project) // Display the results on the console
foreach (Difference difference in stagingVsProduction)
{
if (difference.Name == "<object name>")
{
Console.WriteLine("{0} {1} {2}", difference.Type, difference.DatabaseObjectType, difference.Name);
difference.Selected = true;
}
}
/ comments
To add to this, here is a small code sample to demonstrate Brian's post. (Based on our SQL Compare API sample project)// Display the results on the console
foreach (Difference d...
Thanks for getting back to me.
It turns out that the order of index was changed fairly recently to fix a problem where the indexes didn't properly line up in the SQL Differences pane if you had two tables with the same index ordered differently.
We shouldn't be changing the ordering again, so in time all your scripts should be consistent.
I'm sorry that you have encountered this problem. / comments
Thanks for getting back to me.
It turns out that the order of index was changed fairly recently to fix a problem where the indexes didn't properly line up in the SQL Differences pane if you had two...
Thanks for your post.
SQL Compare will sort the indexes alphabetically by column name, rather than alphabetically by index name. However, SQL Compare shouldn't identify the order of the indexes as a semantic difference between the objects. If I compare the 'before' and 'after' scripts with SQL Compare they are matched as identical.
Is the issue that you would rather have the indexes ordered by index name ascending in the script rather than the current sort order?
Can you let me know what kind of comparison you are performing that is identifying the two objects as different? / comments
Thanks for your post.
SQL Compare will sort the indexes alphabetically by column name, rather than alphabetically by index name. However, SQL Compare shouldn't identify the order of the indexes as ...
Hi Kelly,
I'm a member of the development team working on ANTS Performance Profiler.
Thanks again for the video and reproduction steps. Unfortunately, we haven't had much luck reproducing the crash using the same configuration, so I'm a bit puzzled at what the problem could be. Just out of interest, did changing the profiling mode make any difference? I don't think it's likely to be a similar issue to the KB article as there isn't any code in the empty web app that could be at fault.
It might be worth reinstalling the .net 4.5.1 development pack to see if that helps.
Do you happen to have another machine with a similar configuration you could try this on to see if the problem is machine specific?
Regards,
Chris / comments
Hi Kelly,
I'm a member of the development team working on ANTS Performance Profiler.
Thanks again for the video and reproduction steps. Unfortunately, we haven't had much luck reproducing the crash...
Thanks for your post.
I'm not sure why this would be happening. When it returns to the 'Edit' project screen, is the RedGate.MySQL.Compare.Schema.UI.exe process showing any activity? Is the edit project screen responsive when it returns?
You might also like to check the application logs, which can be enabled by 'right-clicking' on the main title bar in the UI and change the log levels to 'Verbose'. You can view the logs through the same context menu.
Let me know if this helps or not. / comments
Thanks for your post.
I'm not sure why this would be happening. When it returns to the 'Edit' project screen, is the RedGate.MySQL.Compare.Schema.UI.exe process showing any activity? Is the edit pr...
Thanks for your post.
There is no restriction on the trial version, it is fully functional for the complete evaluation period.
The problem is that the current version of SQL Prompt does not currently support xml data type methods. We already have a feature request in our system to provide intelisense for the methods of the xml data type. The feature has been approved for a future version of the tool, but we do not know an exact release version yet. For your reference the feature tracking code is SP-319.
I hope this is helpful. / comments
Thanks for your post.
There is no restriction on the trial version, it is fully functional for the complete evaluation period.
The problem is that the current version of SQL Prompt does not current...