Copy SQL Server 2005 Express database to SQL Server 2000
- From: "Angus" <nospam@xxxxxxxxx>
- Date: Thu, 10 May 2007 18:42:10 +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: Allan Mitchell
- Re: Copy SQL Server 2005 Express database to SQL Server 2000
- Prev by Date: Multiple source columns into one destination column transformation
- Next by Date: Excessive Runtime of SSIS Package from DTExec
- Previous by thread: Multiple source columns into one destination column transformation
- Next by thread: Re: Copy SQL Server 2005 Express database to SQL Server 2000
- Index(es):
Relevant Pages
|
