Using the Import Extension in Azure Data Studio

Question

Using the Import Extension in Azure Data Studio

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
November 29, 2023 at 12:00 am

#4325247

Comments posted to this topic are about the item Using the Import Extension in Azure Data Studio

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Bob Blackburn Newbie Points: 1 More actions · Answer 1

It still doesn't have an overwrite/replace checkbox. I created a python script to upload to Azure databases. When python becomes available in Excel, I'll create a function to upload right from the spreadsheet.

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 2

Yeah, I hate that I always need to go to a new table. That's really annoying.

rstone SSCertifiable Points: 6209 More actions · Answer 3

I have come to like using the DBATools module (e.g., Import-DbaCsv) for csv imports. This is especially true if there is a lot of trial and error or it's something that repeated. However, I'm glad to see it's available, especially if Azure Data Studio is to replace SSMS someday.

RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 4

I think Import-DbaCsv is amazing, but not everyone has or can use dbatools.