Link to home
Start Free TrialLog in
Avatar of NigelRocks
NigelRocks

asked on

Massive Data Migration

Experts,

I'm on a new job where we're doing a huge migration of accouting data (telecomm provider) from an outsourced database to an in-house database.  Fortunately, both are in SQL Server.  However, I'm still running into a few snags.

Are there any tools that can help in a migration like this?  Does anyone have any general advice about this kind of operation?
ASKER CERTIFIED SOLUTION
Avatar of dportas
dportas

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
connect to the target server
open Mircosoft Enterprise Manager
connect to the instance
right click on the target database
import data
follow the wizard

remember, size is realitive..  massive to you and massive to a computer are too different things.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial