How to migrate SQL Server to Postgres in 8 steps

In this video you will learn steps to migrate SQL Server database to Postgres database. All steps are basic SQL scripts. Which are easy to understand and edit.

[farheenmohammad]

Awesome Yogesh! Thanks for all your help just managed to do a transformation from SQL to Postgres successfully.

[IdhayanA]

what about stored procedures and functions ?

[MovieMash]

Hello, for some reason running step-3 script I'm getting this Error = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'Order'. and same kind of error on column with name Key. they are different types for like Order is int and Key Nvarchar. Can't figure out whats causing it. Any ideas what could be causing it ?

[ArunG-iw]

Hello. Error = [Microsoft][ODBC Driver 13 for SQL Server]Unable to open BCP host data-file. I'm getting this type of error in step 3, while exporting the data. Please provide solution if any.

[itvirtual]

There is already an object named 'tempQueries' in the database. always shown and if we drop the temp
queries shown again
please help me

[prasanna]

does it work for windows to linux. I copied the csv from windows to linux server where postgresql is running. When I run the copy command I get invalid byte sequence for encoding "WIN1251"

[sudharsanpramesh]

Got error msg 40515, reference to database and/or server name in 'master..xp_cmdshell' is not supported in this version of SQL server

[dwhpbi]

when i execute script 3 files are not getting in specifies path or location
can you please help me

[SIBUK]

Step 4 does not work for me. It says ERROR: could not open file "whatever.csv" for reading: No such file or directory

[safechanbeh]

Hi sir, how can i change the encoding parameters?, because when executing these scripts he didn't like special caracters like 'à' (french caracter with accent)

[FabianCharris]

Thank you. Eres asombroso, me ayudó muchísimo a migrar la base de datos SQL Server a PostgreSQL. De nuevo, muchas gracias. Saludos desde Barranquilla, Colombia.

[lonewolf]

I am getting error in 3 rd script, it says object tempQueries is already present in the database, i tried renaming it, but didn't work, can u please suggest solution on this ?

[ajitmelepat]

when I execute copy comments, I got this error "ERROR: invalid byte sequence for encoding "WIN1251": 0xff
CONTEXT: COPY paymentmastervisa, line 1 " Can you help me ?

[riyaraghuwanshi]

Hey any script to migrate sql stored procedure to postgresql

[henry]

@techsapphire - Sir, I need your support to migrate Stored Procedures and Functions from MSSQL to Postgresql. Please guide me.

[sheikheshan]

Thankyou so much for posting such informational videos..waiting for the reply

[alastarvamsi]

Hi sir I am getting error in step 3 executed successful but in output unable to open BCP host data file please help me in this

[MrSid]

Thank you so much. It worked like a Charm...😊

[abhijobs]

hlo sir, i have to migrate mysql database to postgresql how can i do this

[rpsharry]

I need help in step exporting to csv file. I am getting error number 2714
Msg 2714, Level 16, State 6, Line 7
There is already an object named 'tempQueries' in the database.
Can u please help me in this regard?