Activity overview
Latest activity by s_solt
ANSI_WARNINGS Project Option
NB I couldn’t find a wishlist on the support forums.
For several years I have wanted a project option to set ANSI_WARNINGS OFF when I am happy to ignore data truncation warnings. I know I can (an...
I know this is an old thread but 18 months later, there still isn't support for Synonyms and the link to the wishlist no longer works.... / comments
I know this is an old thread but 18 months later, there still isn't support for Synonyms and the link to the wishlist no longer works....
Detecting or overriding truncation errors
Of course SQL Compare warns of thoretical truncation when you alter data types or field lengths, but it doesn't check whether any data actually exists in the source database that will be truncated,...
No, the database is an ordinary SQL one. I have my own script that links an access database and then runs through all the tables on the linked server doing:
SELECT * INTO [sqlTable] FROM [msdb]..[msTable]
I then attempt to apply all the other SQL objects and functionality from my master.
Surely you can't compare an SQL database to a linked Access Database! / comments
No, the database is an ordinary SQL one. I have my own script that links an access database and then runs through all the tables on the linked server doing:
SELECT * INTO [sqlTable] FROM [msdb]..[m...
is:
DropAndCreate TABLE
CreateOrAlter PROC
Since Microsoft don't implement this, I would like to see Red Gate to spoof it in in their scripts. / comments
is:
DropAndCreate TABLE
CreateOrAlter PROC
Since Microsoft don't implement this, I would like to see Red Gate to spoof it in in their scripts.
SQL Compare doesn't seem to totally handle dependency
When I need to apply a huge number of schema changes to a target database, SQL Compare doesn't seem to follow a path which takes account of dependency.
I have a target (eg from MS Access) which has...
How do I prevent/track truncation errors on table synch
If I have a client (target) database with populated tables and I want to synchronise it with my development (source) master, there may be records which include data which exceeds the preferred size...