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