CODEWITHSUNDEEP
sqldatabasesql-server-2008msde
akkhatri
akkhatri

Reputation: 1

How to Attach Existing SQL Server 8.0 Database Files to Microsoft Data Engine (MSDE)?

I am trying to attaching microsoft sql server 2008 database into msde 2000 but unable to attach. i googled many sites but still cant find solution. the only thing i found is that newer version cant attached into older version servers...

Please suggest me what can i do? is any way to attach database?

Upvotes: 0

Views: 376

Answers (2)

marc_s
marc_s

Reputation: 755321

There is no way to achieve this - you can never go back in time with SQL Server.

That is: you cannot with any method or trick or hack or workaround attach or restore a newer database (file) to an older SQL Server version.

No way. Doesn't work. Don't even try it. Nope.

You'll need to find a way to synchronize the two databases - both their structure (tables, views, stored procedures etc.) and their data (contents of the tables) - manually, e.g. by using T-SQL scripts to update one database from the other, a tool to help you with that, or whatever means you want to use.

But you cannot in any way, shape or form detach/attach or backup/restore newer SQL Server database files onto an older version.

Upvotes: 0

Ian P
Ian P

Reputation: 1724

What you need to do is:

script out your database structure including stored proceedures, indexes, functions etc. (there is a wizard in SQL management studio).

create an empty database on your MSDE instance.

run the script, making changes where any types of object are not supported in the earlier version of SQL

Bulk insert the data from the later version into the earier version (once again making changes to overcome errors because features are not supported in the earlier version) There is a wizard in in SQL management studio. (Doesnt fix your errors)

Upvotes: 0

Related Questions