将数据从一台服务器传输到另一台服务器 [英] Transfer Data From one server to anather Server

问题描述

假设我有数据库abc并在其中包含多个表.我在另一个服务器xyz中创建了另一个数据库，该数据库具有与abc中相同的表.我想在每个表中将数据从abc传输到xyz，并要记住，由于数据库中存在大量引用，因此xyz表中的ID不会不匹配.
对于前CustomerID和InvoiceID一位客户有多张发票.我要保存带有customerID客户ID的发票在xyz中与abc中不同.

有任何建议我将如何执行.. ??

Hi ,
Suppose I have database abc and heaving multiple tables in it. I have created another database in another server xyz heaving the same tables as in abc. I want to transfer data from abc to xyz in each table and keep in mind that Ids from tables of xyz will not mismatch as there is lots of referencing in the database.
For Ex. CustomerID and InvoiceID one customer have multiple Invoices.I want to save Invoices with customerID customer ID will be different in xyz as in abc.

HAve any suggestions how I will do this .. ??

推荐答案

我有一个建议给你.只需放下XYZ.
1转到ABC选择数据库.右键单击选择任务->.生成脚本
2选择ABC DB，单击下一步
3将选项设置为true任意选项，如果您不了解，则可以将所有选项设置为true.
4选择表/SP或您想要的任何内容.
5选择表/sp的名称
6.单击完成.

它将生成SQL脚本，只需将其复制并粘贴到其他服务器上的脚本即可替换使用并运行脚本

希望对您有帮助

Hi,

I have one suggestion for you. just drop the XYZ.
1 Go to ABC select the database.right click select task-> generate script
2 select ABC DB click on next
3 set the option true whatever option you want,you can set all option true if you don''t understand.
4 select table/SP or what ever you want.
5 select name of table/sp
6. click on finish .

It will generate the SQL script,just copy and past scrip on other server replace the using and run the script

hope this will help you

这篇关于将数据从一台服务器传输到另一台服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！