如何使用 Business Intelligence Dev Studio 迁移表？
我正在尝试将表从远程服务器迁移到本地数据库中。但是，由于该表内的列内容，我不想创建中间 csv 或制表符分隔文件。有些列很大，我真的不想记住所有数据类型。我想知道是否有一种中间格式，我可以将表转储到其中，然后将其重新导入回本地数据库。
有人建议我使用 Business Intelligence Development Studio 来实现此目的，但我对如何实际使用此工具一无所知。也许我使用了错误的关键字集，但谷歌也没有帮助。
有人能指出我正确的方向吗？
I am trying to migrate a table from a remote server into my local database. However, I do not want to create an intermediate csv or tab-delimited file because of the content of the columns inside this table. Some columns are huge and I don't really want to remember all the data types. I was wondering if there is an intermediate format that I can just dump the table into and then re-import it back into my local database.
I was suggested to use Business Intelligence Development Studio for this purpose but am clueless on how to actually use this tool. Maybe I am using the wrong set of keywords but Google is of no help either.
Can someone point me in the right direction?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
（我假设您正在运行 SQL Server 2005+）
如果您可以访问这两个 SQL Server，只需使用数据导入/导出向导即可。
您还可以使用 SQL 脚本生成器，这是一个免费的 SQL 脚本生成器。很棒的工具，它允许您使用其数据编写数据库、表的脚本。有关该工具的详细信息，请参阅 http://sqlscriptgenerator.com/。
是的，您不需要 Business Intelligence Development Studio。
(i am assuming that you are running SQL Server 2005+)
If you have access to both SQL Servers, simply use the Data Import / Export wizard.
You can also use SQL Script Generator, a free & great tool which allows you to script both database, table with it's data. See http://sqlscriptgenerator.com/ for more information about the tool.
And yes, you don't need Business Intelligence Development Studio.
我认为您不需要 Business Intelligence Development Studio 来实现此目的。您应该能够链接远程服务器，运行 外部查询，然后执行 SELECT INTO 语句将表数据直接插入数据库。
I don't believe you need Business Intelligence Development Studio for this. You should be able to link to the remote server, run an external query and then do an SELECT INTO statement to insert the table data directly into your database.