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