Migrate from ADS to Visual Studio Code ...

Question

Hello Folks,

I am in a process of migrating from ADS to Visual Studio Code.

My main goal for usage of ADS was to work with SQL Server databases and things related to it.

In ADS I actively used 'Import Wizard' to create table from files.

I don't see it in Visual Studio Code. I installed mssql extention (SQL Server) but it does not provide this option.

Hence, my questions:

1. do you know if mssql extension is planning to implement something like 'Import' option?
2. what alternative you could recommend meanwhile ... another extension or etc.,?

Thanks

Answer 1

Susja

Thank you for reaching out.

 Yes, the flat file import feature is part of our roadmap for this year. We are actively working to make the MSSQL extension roadmap more visible to customers, enabling them to migrate with confidence when the time is suitable for them. In the meantime, for importing flat files into a database, you might consider the following alternatives:

Use existing tools like SSMS or ADS SQL Server Management Studio (SSMS) or Azure Data Studio (ADS) both offer robust import wizards that let you easily import flat files into SQL Server. ADS won’t be retired until February 28th of 2026, so it can be a valid option until this feature is release on the MSSQL extension. 

Use PowerShell​ PowerShell is another effective option for importing CSV data into SQL Server. Using the built-in Import-Csv cmdlet along with cmdlets from the SqlServer module (such as Write-SqlTableData) allows you to script the import process in a streamlined and efficient manner. This approach is well-documented and can handle both simple and more complex import 

For more details on recommended alternatives, please check the documentation: Recommended Alternatives for SQL Server Capabilities in ADS

Please see ADS retirement main page

http://aka.ms/ads-retirement#recommended-alternatives-for-sql-server-capabilities-in-azure-data-studio

Hope that helps.

Regards,

Oury