{"repo":"PNNL-Comp-Mass-Spec/DB-Schema-Export-Tool","free":true,"listed":false,"github":"https://github.com/PNNL-Comp-Mass-Spec/DB-Schema-Export-Tool","clone":"git clone https://github.com/PNNL-Comp-Mass-Spec/DB-Schema-Export-Tool.git","description":"Exports SQL Server and Postgres database objects as schema files. Exported objects include tables, views, stored procedures, and functions, plus also database properties including database roles and logins. The program can also export table data to create SQL files with an Insert Into statement for each row.","language":"C#","stars":16,"topics":["sql-server","sql-server-database","postgresql","postgresql-database"],"license":"BSD-2-Clause","category":"databases-storage","readme_excerpt":"DB Schema Export Tool The DB Schema Export Tool exports SQL Server or PostgreSQL database objects as schema files. Exported objects include tables, views, stored procedures, functions, and synonyms, plus also database properties including database roles and logins. Uses integrated authentication or a named user to connect to a Microsoft SQL Server database. Uses a named user, password, and port to connect to a PostgreSQL database. Continuous Integration The latest version of the application is available for one month on the AppVeyor CI server Features In addition to creating schema files for tables, views, stored procedures, functions, and synonyms, the program can also export table data to create SQL files with an Insert statement for each row. The DB Schema Export Tool has both a command line interface and a GUI mode. Starting the program without any parameters will show the GUI. The command line interface is useful for automatically exporting schema files on a regular basis. Example command (wrapped here for readability): Console switches SchemaFileDirectory is the path to the directory where the schema files will be saved (aka the output directory) Optionally use named parameter /OutputDir:DirectoryPath To process a single database, use /Server and /DB The server is assumed to be Microsoft SQL Server However, if /PgUser is provided (or PgUser is defined in the parameter file), will treat as a PostgreSQL server Use /DBList to process several databases (separate names with ","default_branch":null,"files":null,"tree":[],"storefront":"/r/PNNL-Comp-Mass-Spec","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/PNNL-Comp-Mass-Spec/DB-Schema-Export-Tool/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}