Comments
Sort by recent activity
Sorry... I did not have "Notify me when a reply is posted" set.... here are the results:
SQL Backup v7.7.0.7
Reading SQB file header of "\KellyBackupsKProdMyDBk_BACKUP_20150405_033627.sqb"
Backup group ID : 142334605
File number : 1 of 1
Threads : 3 (multi-threaded file)
Backup type : 1 (Database)
Native backup size : 18.625 MB
Database size : 563.125 MB
Backup start : Sunday, April 05, 2015 3:36:27 AM
Backup end : Sunday, April 05, 2015 3:36:28 AM
Server name : KProdMSMSQL05
Database name : MyDBk
First LSN : 248000000052800147
Last LSN : 248000000058900001
Checkpoint LSN : 248000000052800147
Database backup LSN : 248000000014200147
name value
exitcode 0
sqlerrorcode 0
filename001 \KellyBackupsKProdMyDBk_BACKUP_20150405_033627.sqb / comments
Sorry... I did not have "Notify me when a reply is posted" set.... here are the results:
SQL Backup v7.7.0.7
Reading SQB file header of "\KellyBackupsKProdMyDBk_BACKUP_20150405_033627.sqb"
Backup g...
Looking over the documentation from RedGate, it appears the syntax should look like this: EXEC master..sqlbackup '-sql "RESTORE DATABASE MSMK_Temp FROM DISK = ''\KellyBackupsKProdMyDBk_BACKUP_20150405_033627.sqb'' WITH MOVE ''MyDBk_Data'' TO ''G:KProdMyDBkMyDBk.mdf'', MOVE ''MyDBk_Log'' TO ''G:KProdMyDBkMyDBk.ldf'' "'
The "Stats = 10" appears to be unsupported. Once I removed it, it appears to work fine.. difference between RedGate syntax/options and Microsoft syntax/options. I just like the "Stats" options on larger (100G+ DBs) to know where we are in the restore process. / comments
Looking over the documentation from RedGate, it appears the syntax should look like this:EXEC master..sqlbackup '-sql "RESTORE DATABASE MSMK_Temp FROM DISK = ''\KellyBackupsKProdMyDBk_BACKUP_201504...
I just remembered something else that might help with the bug fix?
A few of the database(s) that compared tables NOT in the .sdc project files had a comparison done some time ago, where I did a data sync in the opposite direction... i.e., the .sdc file targets ONE database table, DB1 -> DB2, but I did a previous compare (that was never saved as a project) moving some "archive" data from DB2 -> DB1.
This is not true for all of the projects, but definitely for 2 out of the 3 that experienced a problem.
Looking forward to the new release with heavy anticipation! [image] [image] / comments
I just remembered something else that might help with the bug fix?
A few of the database(s) that compared tables NOT in the .sdc project files had a comparison done some time ago, where I did a dat...
Sorry for the delay in getting back a response... too many projects, never enough time!
The table(s) I deal with are typically about 40-60 columns wide. I am transfering anywhere from 200,000 records to 5 million records, depending on what it is I am trying to do (something as large as 5 million being rare).
Nothing unusual about the data... mostly varchars and a few datetime fields. I will typically put some sort of restriction on the data using a WHERE clause (mostly date, ''+getdate()-150+'' or something similar).
I just ran into a situation today where I needed to do a comparison/sync, started the compare then realized almost immediately I forgot the WHERE clause. I selected cancel... same problem.... over 20 minutes now, no cancel. [image]
The servers are not located on the same network/location (going from a remote server to a local server), but network performance has not been an issue (typically). / comments
Sorry for the delay in getting back a response... too many projects, never enough time!
The table(s) I deal with are typically about 40-60 columns wide. I am transfering anywhere from 200,000 recor...
Ok... thanks everyone for your responses! I setup one large batch file and everything seemed to work well (setup on Wednesday, ran on Friday when I was on vacation).
I found one "issue" with setting up the batch file:
"C:\Program Files\Red Gate\SQL Data Compare 5\sqldatacompare" /project:"C:\Documents and Settings\username\Local Settings\Application Data\Red Gate\SQL Data Compare 5\projectA.sdc" /out:"D:\RedGate\ProjectASyncSummary.txt"
If the output file "ProjectASyncSummary.txt" already existed (since this is going to be a scheduled process", the application complained that the file existed and then stopped. My solution was a script to rename the file after it was "created" and "written to", put in the batch file immediately after the sqldatacompare command listed above:
REM Rename File Original Script by Mark Yocom,
for /f "delims=/ tokens=1-3" %%a in ("%DATE:~4%") do (
for /f "delims=:. tokens=1-4" %%m in ("%TIME: =0%") do (
rename ProjectASyncSummary.txt ProjectASyncSummary-%%c-%%b-%%a-%%m%%n%%o%%p.txt
)
)
This will rename the file and attach a date/time stamp. Worked very well!
I would also like to see one enhancement... some sort of "sync complete" comment in the output file would be nice. [image] / comments
Ok... thanks everyone for your responses! I setup one large batch file and everything seemed to work well (setup on Wednesday, ran on Friday when I was on vacation).
I found one "issue" with settin...
Ok... I setup a .BAT file to process a previously created SQL Data Compare project,
"C:\Program Files\Red Gate\SQL Data Compare 5\sqldatacompare" /project:"C:\Documents and Settings\username\Local Settings\Application Data\Red Gate\SQL Data Compare 5\projectA.sdc" /out:"D:\RedGate\ProjectASyncSummary.txt"
I plan on setting this up using Windows Server 2003 Scheduler. However, I have multiple compares/syncs I need to perform weekly. Can I setup all of them in one batch file?
\sqlcompare /project:... projectA.sdc /out:...
\sqlcompare /project:... projectB.sdc /out:...
\sqlcompare /project:... projectC.sdc /out:...
Seems much more efficient than trying to setup a data ompare/sync for each DB and scheduling them all individually.
If I have to schedule them all individually, can they run concurrently (multithreaded)?
Thanks!
JR / comments
Ok... I setup a .BAT file to process a previously created SQL Data Compare project,
"C:\Program Files\Red Gate\SQL Data Compare 5\sqldatacompare" /project:"C:\Documents and Settings\username\Local ...
We found a similar problem to the one posted previously, RGDC* files not being deleted when we ran out of disk space on our SQL Server.
We are using Red Gate Data Compare as follows:
1) Start RGDC on the server.
2) Select an existing COMPARISON PROJECT.
3) Run the project to do the comparison.
4) Modify the parameters of the project after the existing compare was completed without actually closing the comparison (same server, user id, just a different database).
RDGC v. 5.3.0.68
Sounds like we have to actually close out the comparison project, then open it and change the parameters.
Disk space recovered from the C: drive when we changed the tmp file location to a drive with lots of space disk space: 20GBytes. / comments
We found a similar problem to the one posted previously, RGDC* files not being deleted when we ran out of disk space on our SQL Server.
We are using Red Gate Data Compare as follows:
1) Start RGDC ...
Here is a response I received from RedGate (via email):
Regarding the Source Control question you can either use SQL Compare to generate creation scripts if you can connect to the client server.
However if you can’t connect to the client server, SQL Packager (https://www.red-gate.com/products/sql-d ... er-bundle/) will be able to deploy the .sql scripts.
Let me know if you have any questions regarding this.
It appears the "direct" answer to the question is NO, the RedGate product cannot handle individual scripts. I did find the following link that did a good job describing how to connect SSMS and Team Foundation Server: http://blog.discountasp.net/using-team- ... nt-studio/ / comments
Here is a response I received from RedGate (via email):
Regarding the Source Control question you can either use SQL Compare to generate creation scripts if you can connect to the client server.
H...
Yes... that appears to have done the trick! [image]
Might I suggest the FAQ and other command line documentation get an update to include the difference between version 6 and version 8?
Thanks! [image] / comments
Yes... that appears to have done the trick!
Might I suggest the FAQ and other command line documentation get an update to include the difference between version 6 and version 8?
Thanks!
Thanks for the link. I did try and find the answer, but my searches on the RedGate website were not leading me to that particular link.
Actually, since I am trying to EXCLUDE items only in DB2, shouldn't I use the /Exclude:Additional so the items in target DB2 are NOT touched (i.e., deleted)?
Note that I am NOT trying to include or exclude database OBJECTS (views, tables, etc.) but specifically RECORDS in source DB1/Table1 that are missing or different that target DB2/Table1. I want the records that only exist in target DB2/Table1 to not be touched/deleted.
I believe an alternative would be to do /Include:Missing,Different or /Include:Missing /Include:Different (not sure about the syntax)?
Thanks! [image] / comments
Thanks for the link. I did try and find the answer, but my searches on the RedGate website were not leading me to that particular link.
Actually, since I am trying to EXCLUDE items only in DB2, sho...