Backup & Restore DB

Topics: Developer Discussion, Help, Request
Mar 20, 2007 at 10:19 AM
My development environment is W2K3 Server & Sql2005Ent. However, the client's db is Sql2000. So, i need to backup and restore the my DB to client's machine.

Well, since these seems not possible; only some suggestions for export & import data's etc., but my concern is, will there be primary & foreign keys problem, if I do it this way.

Or is there any other way to move the database?

I may try the Sql2000 scripts for CSK, however, i made lots of changes to the DB. And also, if I try to script my db to Sql2000 compatible mode, i give lots of errors (asp.net memberships related). Are there any ways to correct this?

Thanks,
Coordinator
Mar 20, 2007 at 10:40 AM
If you have VS standard or pro, you can use the SQL Publish to Hoster that will generate the SQL 2000/2005 scripts for you.
Mar 20, 2007 at 10:56 AM
i'm trying,
thanks for quick reply