Copy SQL Server 2005 Express database to SQL Server 2000
- From: "Angus" <nospam@xxxxxxxxx>
- Date: Thu, 10 May 2007 18:44:00 +0100
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
.
- Follow-Ups:
- Re: Copy SQL Server 2005 Express database to SQL Server 2000
- From: Erland Sommarskog
- Re: Copy SQL Server 2005 Express database to SQL Server 2000
- From: Dave Patrick
- Re: Copy SQL Server 2005 Express database to SQL Server 2000
- Prev by Date: Re: SQL Profiler and Import Performance Data
- Next by Date: Export dates to CSV
- Previous by thread: transfer tables between databases with only client components
- Next by thread: Re: Copy SQL Server 2005 Express database to SQL Server 2000
- Index(es):
Relevant Pages
|
