Importing Data from Remote SQL Server DB

[barnettjacob]

Hi,

I'm looking to import some data from the company SQL Server database into a local SQL Server Express DB I have created on my PC.

If I wanted to import the entire contents of the 'Inventory' table what would the code be?

Source Data:
server: ab-srv-01
db: maindb
table: Inventory

Thanks in advance.
Jacob

 

[djj55]

On your machine

SELECT * 
INTO Inventory
FROM [ab-srv-01].maindb.dbo.Inventory

this assumes you have permission and are in the database you want to copy to. (USE mydatabase;GO)


djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[barnettjacob]

Thanks, thats great!
Jacob