I have developed a database using SQL Server 2005 Express for 2005 Enterprise. My client now realises they don't have a licence for 2005 and require a copy of the database that will work on SQL Server 2000. I can find plenty of information about migrating from 2000 to 2005 but not the other way round. Is this possible and, if so, I would really appreciate any pointers on how to do it.
Patrick Grey
There is no easy way to do this, neither the classic detach/attach nor backup/restore will work in this case.
Best bet is to script out using Generate Script Wizard and Integration Services
|||...was worried that would be the case. Thanks.
No comments:
Post a Comment