Unanswered: Restoring db's between instances with different sort orders in SQL 7
Developers created their own instance on a test box, but our prod. servers use a different sort order - case sensitive, binary order. Is there any way I can force a restore of their user db's from their test box to our prod. server?
I kinda figured this couldn't be done, at least not using the db engine. So, off to rebuild their box...
Not actually their fault - they used the default install, but it's the prod. servers that use some unusual install config settings. And these developers are an outside crowd, so the blame I guess is our own.