Skip to content
Advertisement

How to create table/view with data from another SQL server?

I have a database managed by a third party vendor and have access to read-only for the tables and views. I would like to be able to create a table from this database in a remote server. Is this possible? If so, how do I do it?

Thanks in advance.

Hey this is what I got from SELECT @@VERSION Microsoft SQL Server 2012 (SP3-GDR) (KB4057115) – 11.0.6260.1 (X64) Jan 9 2018 21:31:12 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor)

Advertisement

Answer

You could create the linked server, if the server of third party vendor is SQL Server, follow the following steps. If the server of third party vendor is not SQL Server, you need to choose other data source, and sometimes need to install the OLE DB driver.

First, enter the connection path of the third party vendor.

enter image description here

Second, enter the account and password.

enter image description here

enter image description here

Third, create the view.

enter image description here

The query format will be

SELECT Column1, Column2 ...
FROM [server path].[db name].[dbo].[table name]

Reference: How to create and configure a linked server in SQL Server Management Studio

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement