|
![]() |
|
| Author |
|
|||||||
|
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? |
|||||||
| #0 09:34pm 19/10/07 |
|
|||||||
|
system
|
--
|
|||||||
| #0 |
|
|||||||
|
Strange Rash
Posts: 586
Location:
|
Not sure about SQL 7, but DTS?
|
|||||||
| #1 09:35pm 19/10/07 |
|
|||||||
|
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?
|
|||||||
| #2 09:52pm 19/10/07 |
|
|||||||
|
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. |
|||||||
| #3 06:15am 20/10/07 |
|
|||||||
|
system
|
--
|
|||||||
| #3 |
|
|||||||
|
| ||||||||