I am wanting to restore a DB from a dump from a SQL 6.5 server to a test SQL 6.5 server then I will upgrade the SQL 6.5 server to a SQL 7. so that we can more easily migrate our data without potentially harming our data in our 6.5 db. when trying to restore the DB I run into the following error.
The database you are attempting to load was dumped under a different sort order ID (42) than the one currently running on this server(52) and at least one of them is a non-binary sort order.
Yeah that pretty much does it. If there is a smarter way to do this I am totally up for it.