Are there any migration strategy docs for moving data from one location to
another ?
Hassan,
I think this question would need a whole lot more details to be answered
properly. For instance, if it is a one-off then SSIS, DTS, BCP, log
shipping, database mirroring might all be relevant. What are the data source
and destination (DB2, Oracle, SQL Server (version?)...). Is there
connectivity between the 2 machines? If it is a regular/continuous process
then replication might be relevant. In this case do you want to replicate
changes to the source system, filter the data in some way, can the data be
changed on the destination server?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment