Skip to content

Instantly share code, notes, and snippets.

@miclip

miclip/convert_sqlserver_pg.bat

Created October 13, 2017 19:02
Show Gist options
  • Save miclip/58c76ba9af37220bbdaa473f4c234274 to your computer and use it in GitHub Desktop.
Save miclip/58c76ba9af37220bbdaa473f4c234274 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
convert_sqlserver_pg.bat
perl ..\sqlserver2pgsql\sqlserver2pgsql.pl -b .\before_script.sql -a after_script.sql -u un
sure_script.sql -k .\kettle\ -sd [DATABASE] -sh localhost -sp 1433 -su sa -sw [PASSWORD] -pd [DATABASE] -ph localhost -pp 5432 -pu pos
tgres -pw [PASSWORD] -f .\MyDb.sql -camel_to_snake
psql [DATABASE] -f .\before_script.sql
.\Kitchen.bat -file ..\..\kettle\migration.kjb -level detailed
psql [DATABASE] -f .\after_script.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment