|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Copy SQL Server 2005 Express database to SQL Server 2000Hello
I have a copy of a SQL Server 2005 Express database - the mdf and .ldf files. If I copy to my machine and in the Enterprise manager try to attach the files I get error 602 - and apparently you cannot do this as the database structure has changed so much. Bearing in mind SQL Server 2005 is customersw so don't really want to install too much software on their machine. so if I can do this all my end that would be preferable. Can I somehow convert the 2005 database to run on my SQL Server 2000? What would I need to install on my machine to achieve this? The SQL Server 2005 Express does not seem to provide much in the way of data export etc. Angus I think the easiest solution is to go to Properties|Options for the database
and change the compatibility level to (80) Sql Server 2000 then backup the database and restore it to the new 2000 server. -- Show quoteRegards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Angus" wrote: > Hello > > I have a copy of a SQL Server 2005 Express database - the mdf and .ldf > files. If I copy to my machine and in the Enterprise manager try to > attach > the files I get error 602 - and apparently you cannot do this as the > database structure has changed so much. > > Bearing in mind SQL Server 2005 is customersw so don't really want to > install too much software on their machine. so if I can do this all my > end > that would be preferable. Can I somehow convert the 2005 database to run > on > my SQL Server 2000? What would I need to install on my machine to achieve > this? The SQL Server 2005 Express does not seem to provide much in the > way > of data export etc. > > Angus > > Dave Patrick (DSPatrick@nospam.gmail.com) writes:
> I think the easiest solution is to go to Properties|Options for the No, this does not work. The compatitibility level only affects how T-SQL> database and change the compatibility level to (80) Sql Server 2000 then > backup the database and restore it to the new 2000 server. code is parsed and behaves. It has nothing to do with the on-disk structure for the database. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Oops, Ok thanks for clarification Erland.
-- Show quoteRegards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Erland Sommarskog" wrote: > No, this does not work. The compatitibility level only affects how T-SQL > code is parsed and behaves. It has nothing to do with the on-disk > structure > for the database. > > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Books Online for SQL Server 2005 at > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx > Books Online for SQL Server 2000 at > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Angus (nospam@gmail.com) writes:
> I have a copy of a SQL Server 2005 Express database - the mdf and .ldf There is a fair chance that the database uses features that are not > files. If I copy to my machine and in the Enterprise manager try to > attach the files I get error 602 - and apparently you cannot do this as > the database structure has changed so much. > > Bearing in mind SQL Server 2005 is customersw so don't really want to > install too much software on their machine. so if I can do this all my > end that would be preferable. Can I somehow convert the 2005 database > to run on my SQL Server 2000? What would I need to install on my > machine to achieve this? The SQL Server 2005 Express does not seem to > provide much in the way of data export etc. available in SQL 2000, so a transfer to SQL 2000 is non-trivial, at least a priori. If you think that SQL Express does not cut it for you, I would suggest that you cough up the 50 USD or similar for a license of Developer Edition of SQL 2005. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics