search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 908 forks source link

Data copy between different sources #8963

Open win32nipuh opened 4 years ago

win32nipuh commented 4 years ago

I have 2 connections: SQL Server and PostgreSQL and I need to transfer data from PostgreSQL DB1 to SQL Server DB2 like I can do it in SSMS using linked server.

How to do it in Azure Data Studio?

Charles-Gagnon commented 4 years ago

You can execute the queries against linked servers in ADS - is there a particular thing you're blocked on?

You could also look into dumping the data into a CSV and then using the Import Wizard to import that file into the SQL table.

Although if you're transferring data usually it's better to use a tool specifically designed for that - such as SSIS - since the performance is going to be a lot better in those applications.

win32nipuh commented 4 years ago

You can execute the queries against linked servers in ADS - is there a particular thing you're blocked on?

You could also look into dumping the data into a CSV and then using the Import Wizard to import that file into the SQL table.

Although if you're transferring data usually it's better to use a tool specifically designed for that - such as SSIS - since the performance is going to be a lot better in those applications.

Yes, you are right, This way SSMS works, but ADS is the new tool and it has connections to both sources, Thats why it may be useful feature to work with both sources do not using linked servers.

For example, SQL Server is installed on Ubuntu, PostgreSQL is installed on Mac OS and ADS works in linux too. I work with these 2 sources.