Some Differences Between SQL Server and Postgres Part 1

Поделиться
HTML-код
  • Опубликовано: 2 янв 2025

Комментарии • 19

  • @elmrdev
    @elmrdev Год назад +1

    Great video, very informative. Thanks!

  • @gregNFL
    @gregNFL 8 месяцев назад

    Good info. Thanks Lu.

  • @sutapakar7522
    @sutapakar7522 9 месяцев назад

    Very informative video. liked it.

  • @microtech2448
    @microtech2448 2 года назад +2

    There is create or alter available in ms sql.

    • @codingwithlu
      @codingwithlu  2 года назад

      Yes you are correct. There is a Create or Alter statement available. I believe this became available in Sql Server 2016. Any version before that you will need to run the "Create" or "Alter" statement separately. I have been so use to the older versions (I started working with Sql Server back in 2008 version).

    • @microtech2448
      @microtech2448 2 года назад

      @@codingwithlu makes sense then :)

  • @mogitube5997
    @mogitube5997 2 года назад +2

    thanks nice vid is there a part 2

    • @codingwithlu
      @codingwithlu  2 года назад +2

      Part 2 will be released this week!

  • @softgandhi
    @softgandhi 5 месяцев назад

    :: is double colon?

  • @joeycopperson
    @joeycopperson Год назад

    i found this helpful.. thanks

  • @hemantpanchal8087
    @hemantpanchal8087 11 месяцев назад

    Can someone pls guide me, which database is preferable for core banking domain between mssql and postgresql?
    apart from Oracle.

  • @ivanmandulov489
    @ivanmandulov489 2 года назад +2

    Bro, you know you can do "CREATE OR ALTER" in SSMS, right?

    • @codingwithlu
      @codingwithlu  2 года назад +2

      You are correct, but not in older versions of Sql Server. I believe that was introduce in Sql Server 2016 and above.

  • @vaishali_0103
    @vaishali_0103 Год назад

    I want to do data migration from MS SQL server to PostgreSQL . can u make a video and give suggestion?
    urgent ?

  • @mohinisharma7645
    @mohinisharma7645 2 года назад +1

    I have joined a new company.
    They want me to do data migration from postgresql to sql server.
    I have experience with sql server but new to postgresql.
    Can you make a video or give any suggestion on it?

    • @codingwithlu
      @codingwithlu  2 года назад

      So there are a few ways. If you are using AWS you can use a tool provided by AWS. The tool is AWS Schema Conversion Tool. Some things to keep in mind is that any customs functions created for source database will most liked not be able to be converted. You will most likely need to manually recreate the function in the target database.