Sql Server Move Issues

bgreene · Post by **bgreene** » Tue Jan 24, 2006 11:59 am

We set up Vault for testing/internal demo on a SQL server 2005 db. Things went well and we bought licenses

Now I want to move the data from the testing 2005 instance into the production instance, which is in SQL Server 2000.

I've tried various things, and cannot seem to get the job done. I can't imagine this is much different than moving from one sSQLserver 2000 box to another but I'm missing something.

Any help/guidance would be greatly appreciated.

Thanks,
Brian

lbauer · Post by **lbauer** » Tue Jan 24, 2006 1:19 pm

Are you trying to restore a SQL Server 2005 database to SQL Server 2000? This may not be possible as the 2005 database may be incompatible with SQL Server 2000.

bgreene · Post by **bgreene** » Tue Jan 24, 2006 1:27 pm

Whether through a restore, a migration, or some other means, we do in fact wish to move that data from a 2005 to a 2000 server.
Are the schemas the same?
Do you have any export/import scripts that will allow us to do this, or is there anyone else that has done it?

lbauer · Post by **lbauer** » Tue Jan 24, 2006 2:46 pm

Before I posted previously I did an Internet search and didn't come up with anything about downgrading SQL 2005 to SQL 2000. This time I tried Google groups and found this:

http://groups.google.com/group/microsof ... 2b48b8a903

The formats are different, so you can't restore or attach a SQL Server 2005 DB onto SQL Server 2000. If upgrading to SQL Server 2005 on that machine is not an option, we might have an alternative. Email Linda at SourceGear.com and we'll see if there's anything we can do.