Comments
Sort by recent activity
Hi Matt,
We have a patched version of SQL Data Compare that should fix this and is available from the sticky below: http://www.red-gate.com/MessageBoard/vi ... php?t=9880
Please note that when specifying the table name, you will need to do so without the owner. For example, in the sample databases with SQL Data Compare there is a table called [dbo].[Contacts]. This would be specified as follows: sqldatacompare /db1:WidgetDev /db2:WidgetLive /s1:"ts-pete\sql2008" /s2:"ts-pete\sql2008" /include:table:"Contacts"
Pete / comments
Hi Matt,
We have a patched version of SQL Data Compare that should fix this and is available from the sticky below:http://www.red-gate.com/MessageBoard/vi ... php?t=9880
Please note that when speci...
Hi Matt,
I am not entirely sure what is going on here, so have opened a support case for you.
I am sending you an e-mail about this now.
Pete / comments
Hi Matt,
I am not entirely sure what is going on here, so have opened a support case for you.
I am sending you an e-mail about this now.
Pete
Hi Dimitar,
When you say ignoring won't work, do you mean on the timestamp colums or the float values?
In theory, another option available to you would be to create a view in each database that trims, casts or rounds the float. I guess you could also round the datetime to the nearest day / hour as well, which may help if you didn't want to ignore timstamp columns. You more than likely though wouldn't be able to update the target though.
If you went with the view approach, you would also need to ensure that comparing views is turned on in the options of SQL Data Compare.
Pete / comments
Hi Dimitar,
When you say ignoring won't work, do you mean on the timestamp colums or the float values?
In theory, another option available to you would be to create a view in each database that tri...
Hi Dimitar,
Would ignoring the timestamp column in this instance work for you? If so, this is in the options of SQL Data Compare.
On the float issue, the only thing you can do is from the tables & views tab, click on columns in comparison and deselect those with the datatype of float.
Pete / comments
Hi Dimitar,
Would ignoring the timestamp column in this instance work for you? If so, this is in the options of SQL Data Compare.
On the float issue, the only thing you can do is from the tables & ...
Hi Neal,
This is indeed possible. If you create a batch file to run SQL Data Compare, you can then set this to run however often you want using Windows Scheduler.
An example batch file that would synch your databases as well as create a report on the differences and generate the SQL script that was run would be something like: @echo off
"C:/Program Files (x86)\Red Gate\SQL Data Compare 8\sqldatacompare.exe" sqldatacompare /db1:WidgetDev /db2:WidgetLive /s1:"ts-pete\sql2008" /s2:"ts-pete\sql2008" /Synch /Export:"C:\Users\peter.peart\Documents\SQL Data Compare\Command Line Reports\ResultSet1" /force /sf:"C:\Users\peter.peart\Documents\SQL Data Compare\Command Line Reports\SynchScript\SynchScript.sql"
A full list of switches though can be found by navigating through CMD to the SQL Data Compare program file, and then running:
sqldatacompare /? /verbose
Or to output this to an HTML file:
sqldatacompare /? /verbose /html >"C:\Users\peter.peart\Documents\SQL Data Compare\Command Line Help.htm"
Pete / comments
Hi Neal,
This is indeed possible. If you create a batch file to run SQL Data Compare, you can then set this to run however often you want using Windows Scheduler.
An example batch file that would s...
Hi there,
I have tested this out myself, and you are right in the SQL Compare doesn't use the owner when creating the proc as you would like. I have added this as a request in our systems under SC-4569, and will hopefully be included in a future release of the tool.
Pete / comments
Hi there,
I have tested this out myself, and you are right in the SQL Compare doesn't use the owner when creating the proc as you would like. I have added this as a request in our systems under SC-...
Just to follow up on this, I managed to reproduce this with Michael's assistance, and have now raised this as a bug within our tracking systems under reference number SP-2881.
Pete / comments
Just to follow up on this, I managed to reproduce this with Michael's assistance, and have now raised this as a bug within our tracking systems under reference number SP-2881.
Pete
Hi Chris,
We have the knowledgebase document detailed on the below link: http://www.red-gate.com/supportcenter/C ... wledgebase\SQL_Backup\KB200708000117.htm
May I ask, where else do you think this detailed? I can think of some places myself, however I don't want to influence your thought process ;-)
Pete / comments
Hi Chris,
We have the knowledgebase document detailed on the below link:http://www.red-gate.com/supportcenter/C ... wledgebase\SQL_Backup\KB200708000117.htm
May I ask, where else do you think this ...
Hi Kishore,
Glad this is all working now for you.
Pete / comments
Hi Kishore,
Glad this is all working now for you.
Pete
Hi Kishore,
As the error messge says, there is an earlier log file that the tool believes can be restored and with this being log shipping, something would suggest to me that for whatever reason the transaction logs in the network share aren't being moved out of it when they have completed the restore.
Is the log with LSN 38052000000181500001 still in the network share? Also, have you specified the MOVETO command as somewhere on the target server that isn't a network share?
Pete / comments
Hi Kishore,
As the error messge says, there is an earlier log file that the tool believes can be restored and with this being log shipping, something would suggest to me that for whatever reason th...