Groups | Blog | Home
all groups > sql server dts > may 2007 >

sql server dts : Copy SQL Server 2005 Express database to SQL Server 2000


Angus
5/10/2007 6:42:10 PM
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

Allan Mitchell
5/11/2007 8:08:17 PM
Hello Angus,

You should be able to use SSIS to take the objects from SQL Server Express
to 2K and then push the data. There could and most likely will be issues
around schemas and object ownerships but what you may want to do is script
out the DB and go through the script and make it 2Kpatable.



--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

AddThis Social Bookmark Button