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).
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?
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.
Great video, very informative. Thanks!
Glad it was helpful!
Good info. Thanks Lu.
Very informative video. liked it.
There is create or alter available in ms sql.
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).
@@codingwithlu makes sense then :)
thanks nice vid is there a part 2
Part 2 will be released this week!
:: is double colon?
i found this helpful.. thanks
Glad it helped
Can someone pls guide me, which database is preferable for core banking domain between mssql and postgresql?
apart from Oracle.
Bro, you know you can do "CREATE OR ALTER" in SSMS, right?
You are correct, but not in older versions of Sql Server. I believe that was introduce in Sql Server 2016 and above.
I want to do data migration from MS SQL server to PostgreSQL . can u make a video and give suggestion?
urgent ?
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?
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.