postgres2SQL

Job ID: 32107511

Budget: $30 – $250 USD

We need a script to export all objects from an postgress database, tables, views, schema's, constraints to CSV.
Then we need an T-sql script to create all these objects (tables, views, schema's, constraints)
The script should be able to create a sql database with all the database objects from Postgres.
Be aware that some datatypes may need extra attention, such as geometry. It should all be fully functional once created, so geometry column, also needs to be a geometry column in SQL.
The last step is also to load all table data from postgress to SQL.
Related categories: SQL PostgreSQL Microsoft SQL Server