Comments
Sort by recent activity
Hi,
SQL Server 2005 is supported in version 4.x and above of the SQL Bundle - if you currently have version 3.x then please contact sales@red-gate.com and they should be able to check your support and upgrades and provide you with details of how to upgrade.
- James
--
James Moore
Red Gate Software Ltd / comments
Hi,
SQL Server 2005 is supported in version 4.x and above of the SQL Bundle - if you currently have version 3.x then please contact sales@red-gate.com and they should be able to check your support ...
Hi Keith,
It is also worth making sure the backup service is running.
This error is often assosciated with the service being unable to start - this can be caused by an incorrect user password being set during the installation of the server components.
Try going to control panel -> administrative tools -> services then finding the SQL Backup Agent and make sure its running, if it is not then right click go to properties and click on the LogOn tab then delete the current password fields and reenter the users password then make sure the service starts and activation requests should begin to work again. / comments
Hi Keith,
It is also worth making sure the backup service is running.
This error is often assosciated with the service being unable to start - this can be caused by an incorrect user password being...
Hi Russell,
The crash seems to be happing during the call to the extended stored procedure to save the options to the registy. This could be being caused by the write to the registry failing due to the SQL Backup service having insufficient permissions. If you grant read and write permissions to the user the SQL Backup service runs as for the HKLM\Software\Red Gate\SQL Backup registry key this crash should no longer happen.
This issue should be fixed in our next release.
Hope this helps,
- James
--
James Moore
Red Gate Software Ltd / comments
Hi Russell,
The crash seems to be happing during the call to the extended stored procedure to save the options to the registy. This could be being caused by the write to the registry failing due to...
If you get in contact with support@red-gate.com they should be able to help you - or alternatively phone our support guys on
1 866 733 4283 (toll free USA and Canada)
0800 169 7433 (UK free phone)
+44 (0)870 160 0037 (rest of the world)
- James
--
James Moore
Red Gate Software Ltd / comments
If you get in contact with support@red-gate.com they should be able to help you - or alternatively phone our support guys on
1 866 733 4283 (toll free USA and Canada)
0800 169 7433 (UK free phone)
...
You might want to try:
mappings.Options = new EngineDataCompareOptions(
MappingOptions.Default,
ComparisonOptions.TrimTrailingSpaces | ComparisonOptions.Default,
SqlOptions.Default);
- James
--
James Moore
Red Gate Software Ltd / comments
You might want to try:
mappings.Options = new EngineDataCompareOptions(
MappingOptions.Default,
ComparisonOptions.TrimTrailingSpaces | ComparisonOptions.Default,
SqlOptions.Default);
- James
--
Jam...
Hi Mike,
If you havn't already could you please try the steps outlined in this thread: http://www.red-gate.com/messageboard/vi ... php?t=1736 If these steps do not resolve your issues then please let me know and we can look into this further.
Thanks,
- James
--
James Moore
Red Gate Software Ltd / comments
Hi Mike,
If you havn't already could you please try the steps outlined in this thread: http://www.red-gate.com/messageboard/vi ... php?t=1736 If these steps do not resolve your issues then please l...
Yes,
This should be possible - If you create a new comparison project and set the source and destination db to be the same then go to the remappings tab and unmap everything then map you two tables together (You might need to map the columns together as well) - then switch back to the "Tables and Views" tab and make sure that the compairson key is set appropriately for that table and its included in the comparison then hit compare now and it should work.
Let me know if you have any problems,
- James
--
James Moore
Red Gate Software Ltd / comments
Yes,
This should be possible - If you create a new comparison project and set the source and destination db to be the same then go to the remappings tab and unmap everything then map you two tables...
Brien,
This should also be possible. Just include all the tables in you comparison then in the results grid uncheck the two columns representing "different" and "only in right hand database" (or use the menu from the actions button).
Unfortunately we do not allow column level removal after the comparison but you can certainly run the comparison without binary/images by removing the column in the tables and views tab.
- James
--
James Moore
Red Gate Software Ltd / comments
Brien,
This should also be possible. Just include all the tables in you comparison then in the results grid uncheck the two columns representing "different" and "only in right hand database" (or us...
Brien,
You should be able to achieve this by Mapping any tables and columns you need to on the mappings tab of the project configuation dialog then manually set the comparison key on the tables and views tab of the project configuation dialog.
- James
--
James Moore
Red Gate Software Ltd / comments
Brien,
You should be able to achieve this by Mapping any tables and columns you need to on the mappings tab of the project configuation dialog then manually set the comparison key on the tables and...
Red Gate released version 2.0 of SQL Prompt this morning and it is availible from http://www.red-gate.com/products/SQL_Prompt/index.htm.
At this time version 2.0 of SQL Prompt is free - and will be until at least 1st September 2006.
- James
--
James Moore
Red Gate Software Ltd. / comments
Red Gate released version 2.0 of SQL Prompt this morning and it is availible from http://www.red-gate.com/products/SQL_Prompt/index.htm.
At this time version 2.0 of SQL Prompt is free - and will be...