Comments
Sort by recent activity
Just a follow up to this as it was dealt with via a private support call. Andrew wished to have leave existing data in a database and then populate additional data into those tables. This can be done by ensuring that the "Delete data from table before generation" button is unchecked, and this button can be found when you are looking at the particular table in question you are populating data for.
Pete / comments
Just a follow up to this as it was dealt with via a private support call. Andrew wished to have leave existing data in a database and then populate additional data into those tables. This can be do...
Ok. Would it be possible for you to right click on the failed restore job in the GUI of SQL Backup and send me the error log for this?
You can send it to support(at)redgate.com and mark it for the attention of me. If you can also quote reference F0027768 that would be great.
Pete / comments
Ok. Would it be possible for you to right click on the failed restore job in the GUI of SQL Backup and send me the error log for this?
You can send it to support(at)redgate.com and mark it for the ...
Thanks for your reply.
Can you confirm if this behaviour demonstrates itself when Backup Exec is disabled, or if Backup Exec is currently using the file when you are attempting the restore?
Pete / comments
Thanks for your reply.
Can you confirm if this behaviour demonstrates itself when Backup Exec is disabled, or if Backup Exec is currently using the file when you are attempting the restore?
Pete
Hi there,
Sorry you are receiving this error; do you have any anti virus software on the target server that is set to automatically scan any files once they are opened?
Pete / comments
Hi there,
Sorry you are receiving this error; do you have any anti virus software on the target server that is set to automatically scan any files once they are opened?
Pete
Hi Rich,
What happens when you reference the project file through CMD? Does that run and is it just the batch file that is failing or is it both?
Pete / comments
Hi Rich,
What happens when you reference the project file through CMD? Does that run and is it just the batch file that is failing or is it both?
Pete
Hi Richard,
Per the below taken from the SQL Data Compare help file, the syntax for referencing a project should be:
sqldatacompare /Project:"C:\SQLDataCompare\Projects\Widgets.sdc"
To confirm, I have tested this on my machine creating a project in SQL Data Compare 8 and running the below through the command line:
sqldatacompare /Project:"C:\Documents and Settings\Peter.Peart\My Documents\SQL Data Compare\SharedProjects\WidgetDev v WidgetLive.sdc"
Once executed, this returns the following from CMD:
C:\Program Files\Red Gate\SQL Data Compare 8> sqldatacompare /project:"C:\Documents and Settings\Peter.Peart\My Documents\SQL Data Compare\SharedProjects\WidgetDev v WidgetLive.sdc"
Red Gate SQL Data Compare Command Line Utility V8.0.2.5
==============================================================================
Copyright © Red Gate Software Ltd 1999-2009
Serial Number: xxx-xxx-xxxxxx-xxxx
Registering databases
Mapping
Comparing databases
Finished
Summary Information
===============================================================================
DB1 = SLS-PETE\SQL2005.WidgetDev
DB2 = SLS-PETE\SQL2005.WidgetLive
Object type Name Records DB1 DB2
Table [dbo].[Contacts] 7 <> <>
Table [dbo].[WidgetDescriptions] 2 <> <>
Table [dbo].[WidgetDescriptions] 1 <<
Table [dbo].[WidgetPrices] 1 <> <>
Table [dbo].[WidgetPrices] 3 >>
Table [dbo].[WidgetPurchases] 854 <> <>
Table [dbo].[WidgetPurchases] 10156 <<
Table [dbo].[Widgets] 1 >>
Table [dbo].[Widgets] 1 <<
If I add the /synchronize switch after the original command then this also synchronizes the databases.
Can you confirm if these project files have been opened through the GUI with SQL Data Compare 8 yet?
Pete / comments
Hi Richard,
Per the below taken from the SQL Data Compare help file, the syntax for referencing a project should be:
sqldatacompare /Project:"C:\SQLDataCompare\Projects\Widgets.sdc"
To confirm, I h...
Hi Richard,
What syntax are you using for your batch file?
The syntax with SQL Data Compare 8 has now changed per the below link: http://www.red-gate.com/supportcenter/C ... 700052.htm
If you want to post your batch file though I can have a look at it for you.
Pete / comments
Hi Richard,
What syntax are you using for your batch file?
The syntax with SQL Data Compare 8 has now changed per the below link:http://www.red-gate.com/supportcenter/C ... 700052.htm
If you want t...
Hi Scott,
I believe that we have a private build that fixes this issue. I will PM you about it.
Pete / comments
Hi Scott,
I believe that we have a private build that fixes this issue. I will PM you about it.
Pete
Hi Satya,
A list of command line arguments can be found by following the below link: http://www.red-gate.com/supportcenter/C ... 700076.htm
You can either use the command line to include and exclude certain tables like the below example:
sqldatacompare /db1:WidgetStaging /db2:WidgetProduction
/Exclude:table:WidgetReferences
And for certain columns:
sqldatacompare /db1:WidgetStaging /db2:WidgetProduction
/ExcludeColumns:WidgetReferences:WidgetName
You appear however to be referencing a project file, therefore if before running the comparison you set to exclude certain tables / columns and save that as a project file then you will be able to use all the settings in the project file for the comparison and synch.
Hope that helps,
Pete / comments
Hi Satya,
A list of command line arguments can be found by following the below link:http://www.red-gate.com/supportcenter/C ... 700076.htm
You can either use the command line to include and exclude...
Hi there,
There is an option in SQL Compare to force column order, thus if you were altering the column order of a table then this forces a table rebuild with the data being preserved in a temporary table whilst the drop and create is being done, unless of course any columns are being dropped.
Would this suit your needs?
Pete / comments
Hi there,
There is an option in SQL Compare to force column order, thus if you were altering the column order of a table then this forces a table rebuild with the data being preserved in a temporar...