Build SQL Database Projects Easily in Azure Data Studio | Data Exposed

Поділитися
Вставка
  • Опубліковано 29 вер 2024

КОМЕНТАРІ • 20

  • @StalinSalgado
    @StalinSalgado 17 днів тому

    Hello thanks fot the videos, I have 2 questions How could I make a name change to a column in an already created table? This would be possible, another question can you join this process with CI/CD?

  • @taqveem
    @taqveem 3 роки тому +1

    why not just concentrate on making SSMS cross platform???

  • @brunoillipronti8641
    @brunoillipronti8641 3 роки тому +1

    Does it work with the PostgreSQL extension? by the way... if ADS add features for Postgres and MySQL, this is gonna become the go-to tool for A LOT OF developers/data analysts

    • @drewskwierskoballa
      @drewskwierskoballa 3 роки тому

      At this time support for Postgres projects is not incorporated into the database projects extension featured in this video, however there is some support for Postgres projects in Azure Data Studio through the Postgres extension. For a quick introduction: techcommunity.microsoft.com/t5/azure-database-for-postgresql/introducing-postgres-projects-in-azure-data-studio/ba-p/1330728
      Support for MySQL is one of our top requests and is on the roadmap. It is tracked on the issue here: github.com/microsoft/azuredatastudio/issues/4904

    • @markusandrehenriksen6030
      @markusandrehenriksen6030 2 роки тому

      Yes it does :) v0.2.7 is out ATM.

  • @wilberthantoniolopezaguila9236
    @wilberthantoniolopezaguila9236 3 роки тому

    Hi. Nice video.
    Is possible to configure mirroring or replication from a Docker contariner to another with Azure Data Studio on a Linux Laptop?

  • @TresorChun
    @TresorChun 3 роки тому

    anyone answer me please, can you use azure database studio to connect to your webpages like myphp admin do?

    • @drewskwierskoballa
      @drewskwierskoballa 3 роки тому

      Support for connecting to MySQL databases in Azure Data Studio is being worked on! You can track this GitHub issue for notifications as it moves forward - github.com/microsoft/azuredatastudio/issues/4904

  • @theAnandKarna
    @theAnandKarna 4 роки тому

    Database Administrator !! WOW

  • @Scleavers
    @Scleavers 2 роки тому

    A couple of years ago I wrote a C# CLI to download the fresh copy of a schema, but the Projects extension is much better

    • @drewskwierskoballa
      @drewskwierskoballa 2 роки тому

      Glad to hear it - and the projects extension is now also available in VS Code if you'd prefer to work there.

  • @ralber01000
    @ralber01000 3 роки тому

    I see no option to debug a stored procedure in Azure using SSDT or ADS. Please advise. Thank you

    • @drewskwierskoballa
      @drewskwierskoballa 3 роки тому

      The functionality for connecting the TSQL debugger is not available in Azure SQL database, utilizing print statements may be a suitable substitution.

  • @stephenmurphy8833
    @stephenmurphy8833 3 роки тому

    can it do unit testing like ssdt?

  • @lucianaaguiar2244
    @lucianaaguiar2244 4 роки тому

    Are this changes versioned?

    • @drewskwierskoballa
      @drewskwierskoballa 4 роки тому +1

      The database project can be checked into source control for version tracking - support for git is integrated with Azure Data Studio. docs.microsoft.com/sql/azure-data-studio/source-control

    • @lucianaaguiar2244
      @lucianaaguiar2244 4 роки тому

      @@drewskwierskoballa thanks!!!!

  • @satishvish88
    @satishvish88 2 роки тому

    How we can do table data deployment like I want to deploy schema and data both for a table

    • @drewskwierskoballa
      @drewskwierskoballa 2 роки тому

      For deploying data with SQL projects you could leverage a post deployment script to insert/merge data.