schema-duplicator
v1.0.32
Published
DDL Duplicator for SQL using Docker
Downloads
4
Readme
SQL DDL Duplicator
- Requires docker
- using sp_GetDDL from Lowell Izaguirre
Received params
| Name | Type | Description | Default Value | Required | | -------------------------- | ------- | ---------------------------------------------------- | -------------------------------------------- | -------- | | dockerURL | string | Display URL if Docker is not installed | https://docs.docker.com/desktop/mac/install/ | ⬜️ | | skipLogs | boolean | Skips logs for actions. It overrides logQueries | true | ⬜️ | | pullImageIfMissing | boolean | Pull Docker Images if they are missing | true | ⬜️ | | intelImageMSSQL | string | Docker SQL Server Image Name for Intel Mac | mcr.microsoft.com/mssql/server | ⬜️ | | intelImageVersionMSSQL | string | Docker SQL Server Image Version for Intel Mac | 2019-latest | ⬜️ | | m1ImageMSSQL | string | Docker SQL Server Image Name for M1 Mac | mcr.microsoft.com/azure-sql-edge | ⬜️ | | m1ImageVersionMSSQL | string | Docker SQL Server Image Version for M1 Mac | latest | ⬜️ | | spTableDDLMSSQL | string | Stored Procedure to get the DDL from Tables | sp_GetDDL | ⬜️ | | spObjectDDLMSSQL | string | Stored Procedure to get the DDL from SQL Objects | sp_helptext | ⬜️ | | createDefaultSP | boolean | Create DDL table stored procedure if doesn't exists? | false | ⬜️ | | mssqlContainerName | string | MSSQL Container Name in Docker | mssql-copy | ⬜️ | | removeMSSQLOnStop | boolean | Remove MSSQL Container on stopMSSQL | false | ⬜️ | | closeDockerOnStop | boolean | Close Docker when calling stopMSSQL | true | ⬜️ | | logQueries | boolean | Display queries while duplicating the DDL? | false | ⬜️ | | originServerMSSQL | string | Origin MSSQL Server Host Name | | ✅ | | originDatabaseMSSQL | string | Origin MSSQL Server Database Name | | ✅ | | originUserMSSQL | string | Origin MSSQL Server User Name | | ✅ | | originPasswordMSSQL | string | Origin MSSQL Server Password | | ✅ | | originSchemaMSSQL | string | Origin MSSQL Server Schema Name | dbo | ⬜️ | | originPortMSSQL | int | Origin MSSQL Server Port Number | 1433 | ⬜️ | | targetServerMSSQL | string | Target MSSQL Server Host Name | | ✅ | | targetDatabaseMSSQL | string | Target MSSQL Server Database Name | | ✅ | | targetPasswordMSSQL | string | Target MSSQL Server Password | | ✅ | | targetSchemaMSSQL | string | Target MSSQL Server Schema Name | dbo | ⬜️ | | targetPortMSSQL | int | Target MSSQL Server Port Number | 1433 | ⬜️ |
Required params to test
Must have quotes at the start and end of values | Name | | ----------------------- | |originServerMSSQL| |originDatabaseMSSQL| |originUserMSSQL| |originPasswordMSSQL| |originSchemaMSSQL| |targetServerMSSQL| |targetDatabaseMSSQL| |targetPasswordMSSQL| |targetSchemaMSSQL| |CONTAINERCREATIONTIMEOUT| |REPLICATIONTIMEOUT| |OPENDOCKERTIMEOUT| |COUNTOBJECTSTIMEOUT| |WAITCONTAINERTIMEOUT|