|
Subject:
|
Database conversion issue
|
|
Posted By:
|
prashantlakhlani
|
Post Date:
|
8/23/2006 7:12:47 AM
|
Hi all,
i develope a website using SQL Server 2005 database working well. Then i come to know that my webserver only supports Sql server 2000. So i need to convert my 2005 database to 2000. i have already try database backup and restore, Database queries etc. is there any suggession or solution for the problem? are there any tools or specified techniques to solve this problem?
|
|
Reply By:
|
David_the_DBA
|
Reply Date:
|
8/26/2006 11:46:51 AM
|
Very few people are migrating backwards but you could try scripting out your database and then running the script in SQL 2000. You will encounter some errors but you should be able to work through them. Then to transfer your data use Import Export Wizard (which will create an SSIS package for you)
David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
|
