top_left top_right
bottom_left
Next Event: Unknown | Forum Rules | QGL Website | Event Registration
openFolder AusForums.com
iconwatfolderLineopenFolder LANs
iconwatfolderLineopenFolder QGL
iconwatfolderLineopenFolder QGL Forum
Author
Topic: MSDE Instance- Attach to SQL Database
Grimy
Posts: 217
Location: Brisbane, Queensland
So i have a msde instance (the folder with master.mdf, mastlog.ldf...) which is on a server that doesn't have SQL enterprise. I want to move to a server that is running SQL 7 enterprise (yes i know, its ancient, but so is the instance). I gogogogled it but didnt find anything overly helpful.

Any ideas?
system
--
Strange Rash
Posts: 586
Location:
Not sure about SQL 7, but DTS?
Hogfather
Posts: 1379
Location: Cairns, Queensland
You should be able to use the SQL Server Management Studio to work with older SQL Server instances, should be a simple detach and attach or backup and restore?
Opec
Posts: 4747
Location: Brisbane, Queensland
Normally you'd either do a full back up of the old DB then restore it in the new DB. Or detach and attach to the new instance.

Seeing that the new instance is MSDE unless you have a frontend tool to connect to the MSDE (surely your old enterprise manager or SQL studio could do that) then not sure how else you'd do it.

If you have the frontend tool then it's pretty easy. The only problem might be that going from SQL server 7 to 2000/2005 MSDE might be some incompatibility in data-types and stored proc etc.
system
--
Not a new post since your last visit.
New Post Since your last visit
Back To Forum
Advertise with Us | Privacy Policy | Contact Us
© Copyright 2001-2026 AusGamers Pty Ltd. ACN 093 772 242.
Hosted by Mammoth Networks - Australian VPS Hosting
Web development by Mammoth Media.