将巨大的表从一个SQL Server数据库复制到另一个SQL Server数据库？ [英] Copy huge table from one SQL Server DB into another SQL Server DB ?

问题描述

您好，将大量数据从一个SQL Server复制到另一个SQL Server的最佳做法是什么？

Hello what's the best practice of copying large amounts of data from one SQL Server into another?

以及如果只使用WHERE子句的某些数量的大型记录会怎么样？ ？

And also what if only certain amounts of large records with using a WHERE clause?

提前致谢。

推荐答案

Hi techresearch7777777，



>>将大量数据从一个SQL Server复制到另一个SQL Server的最佳做法是什么？
b
您想要迁移什么？表或整个数据库？您可以选择许多选项，如日志传送和事务复制。如果您只想迁移某些数据库对象（如一个表），则事务复制将适合您的请求。
如果要迁移数据库，可以使用日志传送或仅使用备份和还原。请参阅

事务复制和
日志传送。



>>如果只使用了一定数量的大型记录，该怎么办？ WHERE子句？

对于这种情况，您可以使用WHERE子句设置事务复制并过滤已发布的数据。请参阅

过滤已发布数据。

Hi techresearch7777777,

>>what's the best practice of copying large amounts of data from one SQL Server into another?
What do you want to migrate? Tables or the whole database? There are many option you can choose like log shipping and transaction replication. If you just want to migrate some database objects like one table, transaction replication will suit your request. If you want to migrate databases, you can use log shipping or just do it with backup and restore. Please refer to Transactional Replication and Log Shipping.

>>what if only certain amounts of large records with using a WHERE clause?
For this situation, you can set up a transaction replication and filter the published data using a WHERE clause. Please refer to Filter Published Data.

这篇关于将巨大的表从一个SQL Server数据库复制到另一个SQL Server数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！