Skip to content Skip to sidebar Skip to footer

Join Remote Database Table With My Local Database Table In Sql Server 2012

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 trie

Solution 1:

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.

Post a Comment for "Join Remote Database Table With My Local Database Table In Sql Server 2012"