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

Question

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.

i think so.. i run the basic queries on ms sql server management studio 18 — Michael Yoo
Welcome to the world of SQL :) I've edited your question to add the SQL Server tag. One thing to know is that various flavours of SQL have different capabilities so it's important to add this info. To get even more specific can you run SELECT @@VERSION then edit the question and add the tag for the version — Nick.McDermaid
Your remote SQL Server will need network access. The simplest approach in the first instance is to follow this guide to create a a linked server (in the server that will contain the new table) docs.microsoft.com/en-us/sql/relational-databases/…. There are many ways to do what you want to do and this is just one of them. — Nick.McDermaid

Epic Chen Epic Chen · Accepted Answer · 2021-09-28T02:57:33

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

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

1 Answers