schema-duplicator

1.0.32 • Public • Published

SQL DDL Duplicator

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

Readme

Keywords

none

Package Sidebar

Install

npm i schema-duplicator

Weekly Downloads

2

Version

1.0.32

License

ISC

Unpacked Size

130 kB

Total Files

16

Last publish

Collaborators

  • cass2304
  • josue.sosa