Microsoft SQL Server - Deployment - 1.6

Before deploying the Generated Artifacts, please:

• Generate the Artifacts
• Download the generated Artifacts
• Replace the placeholders in the Generated Artifacts

You should now have the SQL scripts ready for deployment.

Deploy the generated Artifacts

We will explain deploying the generated artifacts using the possible target environment for Microsoft SQL Server.

To deploy the generated Artifacts:

• Open Powershell
• Navigate to your generated artifacts folder:

--Example
cd C:\XXXXXXXXX\20240219144515

• Execute the Powershell script helper for deployment:

.\deploy.ps1

• The prompt asks you for the server or instance name:
  
• Enter a server or instance name
  

• Enter a username
  

• If you enter a username, enter the password
  
• You have a similar result: 
  
  -------------------------------------------------------------------------------------------------------------------------
  

• You should now have the Target system created with the structure of future data and the Load Control structure:

You can now load the data with the following load controls:

• Load the data with a native load control
• Load the data with Apache Airflow