将数据从一个DB移动到另一个DB [英] Moving data from one DB to another DB

问题描述

你好朋友，
我想生成将数据库实体从一个数据库移动到另一个数据库的脚本.

我有3个不同的服务器(开发，测试和运行中的服务器)

我将在开发服务器上生成脚本，该脚本应为所有服务器通用.

我尝试了以下

hello friends,
I want to generate script to move DB entities from one DB to another.

I have 3 different servers (development, test and live)

I will generate script on development server, this script should be common to all servers

I tried following

DB->Tasks->Generate Scripts..

它会打开脚本生成向导

在此向导中，我选择实体，然后选择要编写脚本的数据类型选项
Schema and data

问题是，所有3个服务器将具有不同的数据，因此运行此脚本将复制错误的数据

你知道怎么做吗..

预先感谢

It opens script generating wizard

In this wizard i select entities and select types of data to script option to
Schema and data

Problem is, all 3 server will have different data so running this script will copy wrong data

Any idea how to do it..?

Thanks in advance

推荐答案

根据需要将自己的存储过程写入作业，并从代理任务中调用它.

Write your own stored procedure to to the job as you need and call that from the agent task.

检查 http://stackoverflow.com/questions/10028805/transfer-data -from-one-database-to-another-database [ ^ ]讨论.尽管我尚未测试，但您可以尝试.

谢谢.

Hi,

Check http://stackoverflow.com/questions/10028805/transfer-data-from-one-database-to-another-database[^] discussion. although i have not tested but you can try it.

Thanks.

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