database migration
-
sup peeps,
We are currently exiting our current domain and moving to a new one (domainA to domainB). The SQL server will need to be rebuilt from scratch. We are getting rid of some hardwares and will be utlizing ESX. I got some information from Microsoft already but I was wondering if anyone has done this before and what software they utlizied to make this migration as painless as possible.
thanks.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :. -
it is fairly simple -
old server:
export logins or copy via dts
backup dbs (use a script) or detach and move files
script jobs
script replication
note linked servers (not aware of a script tool)
new server:
import logins
restore dbs (use a scirpt) or attach (may have to fix user logins)
run job script
run replication script
add linked servers
move dts packages from old server to new
create maint. plans
that should cover the major tasks...
-
What is "ESX" ???
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
-
Todd, Thanks.
That's the game plan I have as well, I was hoping there would be some SQL migration tool like they have for Windows
.ESX is a product by VMWare.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :. -
Thanks Oberion. Have a great day !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply