We're having some fun and games when trying to convert between SQL server versions. Working with both 2000 and 2005 we need to switch data from one version to another ... and back.

We've tried to detach/attach and that doesn't work because of the changes to the SQL schema.

We've tried to export from 2005 to 2000 and cannot seem to get the primary keys or default values to carry across.

We've generated scripts from the 2005 database, which just don't work in 2000.

Can anyone suggest a solution?

Regards,

Sean Anderson

__________________
Regards,

Sean Anderson

First and most obvious suggestion would be to settle on 2005 instead of flopping back and forth. :D Why do you need to keep flopping back and forth?

--Jeff Moden

I quite agree, but I develop commercial software and much as I would like, the customers aren't always willing/able (and it well out of my control) to keep up to date with the latest versions of the software. The software supports Access and both versions of SQL ... and it's bad enough that we have to flick between Access/SQL.

Basically, the software is developed in one version (in house) and converted to match the customer before delivery.

Regards,

Sean Anderson