1.0.32 • Published 4 years ago
schema-duplicator v1.0.32
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|
1.0.32
4 years ago
1.0.31
4 years ago
1.0.30
4 years ago
1.0.29
4 years ago
1.0.28
4 years ago
1.0.27
4 years ago
1.0.26
4 years ago
1.0.25
4 years ago
1.0.24
4 years ago
1.0.23
4 years ago
1.0.22
4 years ago
1.0.21
4 years ago
1.0.20
4 years ago
1.0.19
4 years ago
1.0.18
4 years ago
1.0.17
4 years ago
1.0.16
4 years ago
1.0.15
4 years ago
1.0.14
4 years ago
1.0.13
4 years ago
1.0.12
4 years ago
1.0.11
4 years ago
1.0.10
4 years ago
1.0.9
4 years ago
1.0.8
4 years ago
1.0.7
4 years ago
1.0.6
4 years ago
1.0.5
4 years ago
1.0.4
4 years ago
1.0.3
4 years ago
1.0.2
4 years ago
1.0.1
4 years ago
1.0.0
4 years ago