Copy SQL Server 2005 Express database to SQL Server 2000

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.
Regards,
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
> database and change the compatibility level to (80) Sql Server 2000 then
> backup the database and restore it to the new 2000 server.
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, esquel@.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.
Regards,
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, esquel@.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