Comments
Sort by recent activity
I've just added an experimental option to stop the scripting of "ALTER .... COMPILE" statements.
This is currently not in the default product so if you want to try it out just drop an email to support@red-gate.com / comments
I've just added an experimental option to stop the scripting of "ALTER .... COMPILE" statements.
This is currently not in the default product so if you want to try it out just drop an email to supp...
I suppose you could do something like introduce a trigger for inserting into the table at the beginning of the script and at the end of the migration script you could remove the trigger so it wouldn't effect the normal operation of the table. We've not plans to introduce a feature allowing you to edit a "template" of the insert script for want of a better term at present. / comments
I suppose you could do something like introduce a trigger for inserting into the table at the beginning of the script and at the end of the migration script you could remove the trigger so it would...
Thanks for that I'll look into it. Hope apart from that you like the filter feature as it should enable people with very large tables that change only via appends to compare a lot quicker.
Have you had a look at the compare using checksum feature in the options? That makes tables that infrequently change compare in a fixed time regardless of the size of the table. / comments
Thanks for that I'll look into it. Hope apart from that you like the filter feature as it should enable people with very large tables that change only via appends to compare a lot quicker.
Have you...
There is a feature called object locking. This works via inserting triggers for object modifications not allowing modifications if the object has been locked by another user.
You can read more about this at. http://documentation.red-gate.com/displ ... ng+objects / comments
There is a feature called object locking. This works via inserting triggers for object modifications not allowing modifications if the object has been locked by another user.
You can read more abou...
I'll put it into our bugs database as a thing to watch out for and we'll get some internal tests going to see if we can find out what's going on. If you have a database that is particularly prone to it or a cunning way to get the
problem to show itself that would be wonderful.
Thanks / comments
I'll put it into our bugs database as a thing to watch out for and we'll get some internal tests going to see if we can find out what's going on. If you have a database that is particularly prone t...
Have you managed to reproduce this problem consistently or does it just seem to be intermittent? / comments
Have you managed to reproduce this problem consistently or does it just seem to be intermittent?
Can I ask what size of tables you were using to compare - if you click cancel Data Compare will currently continue until reading the current table has finished and then cancel. If you have very large tables this could be the 'hang' effect you're both seeing.
Also you're both ok for disk space I assume? / comments
Can I ask what size of tables you were using to compare - if you click cancel Data Compare will currently continue until reading the current table has finished and then cancel. If you have very lar...
Have you tried any of the new features of sql 2005 in your database like [[n]varchar(max), varbinary(max), CLR data types, XML fields and indexes?
Nice to hear it's working for you, I think you'll be impressed with the new DTS Compare if you've ever seen the old one - it's a total rewrite and is so much better it's hard to believe. / comments
Have you tried any of the new features of sql 2005 in your database like [[n]varchar(max), varbinary(max), CLR data types, XML fields and indexes?
Nice to hear it's working for you, I think you'll ...
Thanks for the feedback - nice to hear from somebody just saying 'it works'. [image] / comments
Thanks for the feedback - nice to hear from somebody just saying 'it works'.
Brian speaks the truth - there are certain selections of bytes that simply shouldn't be put into character fields. If you find yourself storing encrypted information in your database you should seriously consider putting this into a varbinary or image field. / comments
Brian speaks the truth - there are certain selections of bytes that simply shouldn't be put into character fields. If you find yourself storing encrypted information in your database you should ser...