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
Showing posts with label docs. Show all posts
Showing posts with label docs. Show all posts
Wednesday, March 7, 2012
Data Migration Strategy from corporate offices to new datacenter
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
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
Data Migration Strategy from corporate offices to new datacenter
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
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:
Posts (Atom)