Comments
Sort by recent activity
Hi Dan
I'm not starting from scratch. The databases are in production use. I need to end up with a single simple, relable script that I can run on our test systems, then on the production systems one weekend after a full backup(!).
David / comments
Hi Dan
I'm not starting from scratch. The databases are in production use. I need to end up with a single simple, relable script that I can run on our test systems, then on the production systems o...
Hi Dan
I had hoped you might come up with a solution that I had missed.
Thanks for looking, anyway [image]
I've found a manually intensive but simple way of changing the collation order on a field in Enterprise manager. So I might just copy a database, then manually change the collation every char field in every table in the copy. Then I can use SQL Compare to produce the ALTER script for all the "real" databases.
Or I will generate a complet set of table CREATE scripts and attempt some sort of WSH or macro to convert them to ALTERING the char (nvarchar, ntext, etc. fields) and removing references to other field types...
Either way, it's an afternoon's work (at least). I'll let you know how it goes.
Thanks
David / comments
Hi Dan
I had hoped you might come up with a solution that I had missed.
Thanks for looking, anyway
I've found a manually intensive but simple way of changing the collation order on a field in Ente...
Hi Dan
Yes, thanks, I know about this option.
Its easy to generate a script to CREATE every table and column in a dtabase, but what I don't see is how to generate a script that will ALTER every column in an existing database to make them the same as they are (except for the collation).
If I could generate that script then I could easily remove the collation part of it.
David / comments
Hi Dan
Yes, thanks, I know about this option.
Its easy to generate a script to CREATE every table and column in a dtabase, but what I don't see is how to generate a script that will ALTER every col...