Comments
Sort by recent activity
I believe it's just the target machine, so I'm slightly surprised you're seeing that crash.
Do you have Red Gate SQL Backup installed on the machine, and if so, which version?
Many thanks,
Robert / comments
I believe it's just the target machine, so I'm slightly surprised you're seeing that crash.
Do you have Red Gate SQL Backup installed on the machine, and if so, which version?
Many thanks,
Robert
Hi,
If you're not using SQL Backup, you might want to give it a go for the moment - hopefully the issue should be addressed properly in the patch release of Data Compare (expected early next year, I think), but this should get you running for the moment.
SQL Log Rescue shouldn't have any effect, so there's no need to remove that.
Thanks,
Robert / comments
Hi,
If you're not using SQL Backup, you might want to give it a go for the moment - hopefully the issue should be addressed properly in the patch release of Data Compare (expected early next year, ...
Hi Paul,
I'm afraid at the moment we don't support programmatic modification of the script list. We'll bear this in mind when we're looking at future versions, though - so thanks for the suggestion!
Just to clarify, do you need something that lets you modify the list "on the fly" (i.e. execute one script, modify the list, execute the next, modify the list etc.), or do you just want to be able to create a list of scripts programmatically, then run them all in one go?
Thanks,
Robert / comments
Hi Paul,
I'm afraid at the moment we don't support programmatic modification of the script list. We'll bear this in mind when we're looking at future versions, though - so thanks for the suggestion...
Hi,
Thanks for the comments. If you want to deploy objects to multiple servers, I'd suggest you use a tool like SQL Compare to synchronize your source database to a blank database, then use the resulting SQL script in Multi Script.
As for saving projects, this is definitely something we're considering adding in a future version - it's in the issue tracking system already!
Many thanks,
Robert / comments
Hi,
Thanks for the comments. If you want to deploy objects to multiple servers, I'd suggest you use a tool like SQL Compare to synchronize your source database to a blank database, then use the res...
Hi,
Thanks for the comment, and glad it works for you :-D. With respect to pricing, you'll notice that at the moment our online shop only offers 1, 5 and 10 server versions of Multi Script.
However, if you give our sales team a call, they'll be able to sort you out with a license for as many servers as you need. I believe it's $495 for an "unlimited" license, but they'll be best placed to give you the details.
Hope that helps,
Robert / comments
Hi,
Thanks for the comment, and glad it works for you :-D. With respect to pricing, you'll notice that at the moment our online shop only offers 1, 5 and 10 server versions of Multi Script.
However...
Hi,
Sorry that's not working for you - it's not an error I've seen before! Could you confirm what version of SQL Server the backup was originally taken on?
Another thing to try, if you've got access to the live copy of that database, is to run the following query: select * from sys.objects where name='sysclsobjs'
If you could post the results back here, that might help in tracking it down.
Many thanks,
Robert / comments
Hi,
Sorry that's not working for you - it's not an error I've seen before! Could you confirm what version of SQL Server the backup was originally taken on?
Another thing to try, if you've got acces...
Hi,
At the moment, we don't support custom parameters in WHERE clauses - we'll keep it in mind for the future, though. If you need this kind of flexibility, I'd look at the SQL Toolkit, since that would let you do this sort of thing behind your own user interface.
Thanks for the suggestion,
Robert / comments
Hi,
At the moment, we don't support custom parameters in WHERE clauses - we'll keep it in mind for the future, though. If you need this kind of flexibility, I'd look at the SQL Toolkit, since that ...
If I remember correctly, in V3, if you start the thread then set the name, ANTS Profiler will pick it up correctly, but if you set the name before starting the thread, we won't.
Hope that helps,
Robert / comments
If I remember correctly, in V3, if you start the thread then set the name, ANTS Profiler will pick it up correctly, but if you set the name before starting the thread, we won't.
Hope that helps,
Ro...
Hi,
That's very strange! What architecture / OS is the high performance server, out of interest?
The only other thing I can think of is that if you're running the comparison on the same box as the database is coming from, you're causing a whole load more disk seeks as SQL Server reads data then Data Compare writes it. However, I'd be amazed if it made as much of a difference as you're seeing.
Lastly, are you comparing between two live databases, or is one a backup?
Thanks,
Robert / comments
Hi,
That's very strange! What architecture / OS is the high performance server, out of interest?
The only other thing I can think of is that if you're running the comparison on the same box as the ...
Hi,
Yes, if I understand correctly, Data Compare should manage that nicely. Start by comparing the table(s) affected, as that will show you what data is missing from both sources (i.e. that which you lost from the live as a result of the page tear, and that which isn't in the backup because it's more recent than that).
You'll then notice the check boxes on the main grid, with the ones on the right being labelled "rows that only exist in <target database>". You'll want to untick these, at which point SDC won't delete rows that already exist in the target.
Of course, as with anything like this you should make sure you have a backup of the production system before doing this!
Hope that helps,
Rob / comments
Hi,
Yes, if I understand correctly, Data Compare should manage that nicely. Start by comparing the table(s) affected, as that will show you what data is missing from both sources (i.e. that which y...