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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.