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.
Second, enter the account and password.
Third, create the view.
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