database migration
-
hi all,
I would like to know which is the best way to migrate the database from one server to onother.
backup-restore, detach-attach or with the dts.
I would like to know, also, if i can migrate a database on sql standard edition to a sql enterprise edition with a backup-restore or detach-attach database.
thanks
Marco Montanari
Marco Montanari -
Hi,
I prefer doing backup (with verify)-restore, then scripting out any jobs etc. Seems cleaner, and less hassle doing it this way.
As far as I know you can migrate up to enterprise, whether one of the resident Yodas (sql masters
) has issues with it it would be nice to know.Ritch
*I didn't do anything it just got complicated*
"I didn't do anything it just got complicated" - M Edwards -
I think this really boils down to the size of the database.
If it's a small database, I'd just detatch it and copy it to the new server and reattatch it. If it's sizable, then I'd run a backup and zip it or use SQLLiteSpeed if you have it and move it that way.
I really don't use DTS for moving databases..
Yeah, you should be able to restore a database from standard into enterprise.
Clive Strong
-
It also depends on whether you have downtime, if you do, detach and attach may be the way, otherwise, you need to backup/restore or DTS.
-
Detach and attach hands down is the fastest way. The only question is can you take your database offline?
If you have the room make a copy of it on the spot, and then bring that database back online. Then copy it over and attach it on the new server.
John Zacharkan
John Zacharkan
) has issues with it it would be nice to know.Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply