usage: mssql2pg.py [-h] [-p PASSWORD] [-d DESTINATION_DATABASE]
                   [-f OUTPUT_FILE_NAME] [-u] [-n RECORD_COUNT]
                   [-x EXCLUDE_SCHEMAS]
                   host_name database_name login_name

Convert Microsoft SQL Server database into PostgreSQL. Produces .sql script
that can be executed with psql.

positional arguments:
  host_name             SQL Server host name
  database_name         Source database name
  login_name            Login name

optional arguments:
  -h, --help            show this help message and exit
  -p PASSWORD, --password PASSWORD
                        Password for the login_name
  -d DESTINATION_DATABASE, --destination-database DESTINATION_DATABASE
                        If not provided, destination database name will be the
                        same as source.
  -f OUTPUT_FILE_NAME, --file OUTPUT_FILE_NAME
                        If not provided, script will be printed to standard
                        output.
  -u, --underscore      Convert CamelCase into underscored_identifiers
                        (schemas, tables and columns).
  -n RECORD_COUNT, --limit_records RECORD_COUNT
                        For test runs, process only provided number of records
                        per table. WARNING: foreign keys may not import
                        properly.
  -x EXCLUDE_SCHEMAS, --exclude-schemas EXCLUDE_SCHEMAS
                        Comma separated (no spaces) list of schemas that will
                        be excluded from export. If not provided, all schemas
                        will be processed.

python3 mssql2pg.py SqlServer PgConversionExample user1 p4ssw0rd -f example.sql -d conversion_example -u

--
-- PREPARE DATABASE

\connect postgres
drop database ubt;
create database ubt;
\connect ubt

CREATE EXTENSION "uuid-ossp";
        
--
-- CREATING SEQUENCES
CREATE SEQUENCE ourfurnature_seq;

--
-- CREATE TABLES
CREATE TABLE ourfurnature (
    id INT NOT NULL DEFAULT nextval('ourfurnature_seq'),
    name VARCHAR(50)
);
ALTER TABLE ourfurnature ADD PRIMARY KEY (id);

--
-- INSERT DATA
\echo
\echo Importing table [ourfurnature]
\echo
COPY ourfurnature (id, name) FROM stdin;
1	table
2	chair
3	bed
\.

--
-- UPDATING SEQUENCE START VALUES
ALTER SEQUENCE ourfurnature_seq START WITH 4;