We have a database that was developed in SQL2008. We want to put it into production. Unfortunately, our Production DB Server is SQL2000.
What is the best way to migrate the DB.
Note the DB is simply a collection of Datatables that have been created from our ERP system. There are no Stored Procedures/Triggers, and nothing fancy about the data, so I'm not worried about running into an issue where the DB is using new features that 2000 won't handle.
TIA