Maybe it even looks like this:įirst things first, we’re going to go and grab the latest “SQL Server Import’ extension from the extension marketplace. ![]() So let’s say we’ve got ourselves a good ol’ comma separated file. Let’s give it a whirl to see how it all works. Likewise, there’s also an extension for importing flat files in your databases, too. For instance, did you know you can now connect and work with PostgreSQL databases in Azure Data Studio? Just like Visual Studio Code, you can add extensions to add new functionality and features to your installed editor. If you open that up, there’s a decent amount (and growing almost every day) of extensions you can add to your client. Over on the left-hand side of the UI, there’s an icon that lists extensions. If you’ve only downloaded the binary for Azure Data Studio, loaded it up, connected to a server and ran a query, you may have missed out on one of the best things it offers: extensions. It turns out that you can, but you just need to think fourth-dimensionally, Marty. One thing I’ve overhead is that if you want to load data to a database, you’re still locked into using a tool like SSMS to import or export data. But that doesn’t stop people from pooh-poohing it, complaining about things it can’t do compared to what they’re familiar with. Without starting an argument, I don’t think of it as a replacement I view it as a side-by-side tool with a stronger focus on development than something like SSMS where I can do more administrative work. ![]() Still, I get feedback from people all the time that they don’t think it’s a good replacement for SQL Server Management Studio (SSMS). I love it, and I’m happy to see people using it either where I work or out in the wild. By now, you’ve probably heard of Azure Data Studio, the lightweight, cross-platform tool for data professionals to connect to, query, and otherwise explore data sources for all sorts of databases, and not just Microsoft SQL Server (see below).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |