Comments
Sort by recent activity
There is another thread that discusses the same problem with slowness and freezing... Here are some additional findings so far: 1. After disabling the "Enable Code Analysis" option, the freezing went away as I mentioned before. 2. Something (either SSMS or RedGate Prompt) is causing periodic slowness on my PC where either SSMS would have a hour glass (spinning circle) or my entire system would suddenly stop responding. - Note that,with stopping all instances of SSMS (I typically an have 4-6 running at once), the problem went away. 3. The problem appears to be related to WmiPrvSE.exe / comments
There is another thread that discusses the same problem with slowness and freezing... Here are some additional findings so far: 1. After disabling the "Enable Code Analysis" option, the freezing we...
Glad to hear/see this is not just me having this problem.... and I do appear to have the latest version of SQL Prompt... SQL Prompt 9.1.2.4363 Microsoft SQL Server Management Studio 14.0.17224.0 Microsoft Analysis Services Client Tools 14.0.1016.244 Microsoft Data Access Components (MDAC) 10.0.16299.15 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.11.16299.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 6.3.16299 The interesting part is it only appears to happen in one SSMS window that is connected to one SQL Server... I typically have 5-6 SSMS windows/instances running (one for each server). The one SSMS window hangs but all of the other SSMS windows work fine. Unfortunately, I have to close them all out, including the "hung" instance, then re-open the windows. / comments
Glad to hear/see this is not just me having this problem.... and I do appear to have the latest version of SQL Prompt... SQL Prompt 9.1.2.4363Microsoft SQL Server Management Studio 14.0.17224...
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...