Tables with PgInsert set to true will have data insert commands formatted as PostgreSQL compatible
pg_dump.exe will obtain the password from this file if it exists.The format is server:port:database:username:password.As described below, you can create a file named nf at %APPDATA%\postgresql to track passwords for PostgreSQL users.Use /PgPass to define the password for the PostgreSQL user Use /PgUser to define the username to use to connect to a PostgreSQL database
If not defined, will use Windows Integrated Authentication.Use /DBUser and /DBPass to specify a username and password for connecting to a SQL Server instance Use /DBList to process several databases (separate names with commas) However, if /PgUser is provided (or PgUser is defined in the parameter file), will treat as a Postgres server.The server is assumed to be Microsoft SQL Server.To process a single database, use /Server and /DB Optionally use named parameter /OutputDir:DirectoryPath.SchemaFileDirectory is the path to the directory where the schema files will be saved (aka the output directory) DB:Database /DBList:CommaSeparatedDatabaseName
The command line interface is useful for automatically exporting schema files on a regular basis.Įxample command (wrapped here for readability): Starting the program without any parameters will show the GUI. The DB Schema Export Tool has both a command line interface and a GUI mode. The program can also export table data to create SQL files with an Insert statement for each row. In addition to creating schema files for tables, views, stored procedures, functions, and synonyms, The latest version of the application is available for six months on the AppVeyor CI server
Uses a named user, password, and port to connect to a PostgreSQL database. Uses integrated authentication or a named user to connect to a Microsoft SQL Server database.
Plus also database properties including database roles and logins. The DB Schema Export Tool exports SQL Server or PostgreSQL database objects as schema files.Įxported objects include tables, views, stored procedures, functions, and synonyms,