将远程数据库表与我在 SQL Server 2012 中的本地数据库表连接起来 [英] Join Remote database table with my Local database table in SQL Server 2012

问题描述

我使用的是 SQL Server 2012 Management Studio.我试图连接到远程数据库.我能够成功连接，但我只能访问四个视图.我尝试了以下步骤将表与本地表连接起来.

I am using SQL Server 2012 Management Studio. I tried to connect to a remote database. I was able to connect successfully but i was restricted to access only for four views. I tried the following steps to join the table with my local table.

1. 我尝试使用链接服务器，但由于权限限制我无法添加远程服务器，因此我无法修改SP_LinkedServer.

我尝试复制该表，但无法将其复制到本地数据库.

I tried to copy the table but i was un-able to copy it to my local database.

我打算将本地表与远程表进行比较.我是 SQL Server 的新手，很想学习.理解有误请指正.

I am planning to compare my local table with my remote table. I am new to SQL Server, curious to learn. Please correct me if have a wrong understanding.

感谢您的帮助

推荐答案

您应该尝试使用 SQL Server 导入和导出向导:

You should try using the SQL Server Import and Export Wizard:

http://msdn.microsoft.com/en-us/library/ms140052.aspx

如果可能，您可以从一台服务器导出数据，然后使用向导将其导入到另一台服务器.

If possible you could export the data from one server and import it to the other using the wizard.

如果这是不可能的，那么您可以从一台服务器导出到一个文件，然后从一个文件导入到另一台.

If this is not possible then you could export to a file from one server, and then import from a file onto the other.

这篇关于将远程数据库表与我在 SQL Server 2012 中的本地数据库表连接起来的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！