Docker Integration
Last updated
Was this helpful?
Last updated
Was this helpful?
DataFakery Studio provides seamless integration with Docker containers, allowing you to manage your database environments efficiently. You can start, stop, and create new database containers, including MSSQL, MySQL, and PostgreSQL, and extract the Data Source information for direct access within your DataFakery project.
Navigate to the Docker Containers section in the ribbon toolbar to manage your containers.
Close: Exit the Docker Container Integration interface.
Start new Container: Launch a new database container.
Use as Data Source: Extract Data Source from a running/stopped container to use directly in your DataFakery project.
Start Container: Start a selected container from the list of existing containers.
Stop Container: Stop a selected running container.
Refresh Containers: Refresh the list of containers to display the latest status.
Select the MS SQL Server tab in the Create Docker Container interface.
Choose the desired version and Docker image for your MSSQL server. For example, Microsoft SQL Server 2022 (mcr.microsoft.com/mssql/server:2022-latest).
The default port is 1433. If needed, you can change this to another available port.
Enter a strong password for the SA (System Administrator) account. This password must be strong; otherwise, the container will not start. Click on the ... button to generate a random strong password.
Choose the appropriate license edition for your MSSQL server. Options include Developer, Express, etc.
Click on Start new Container
Once you have created your MSSQL Docker container, navigate back to the Docker Container management window.
Locate your newly created MSSQL container in the list of Existing Containers.
Verify that the status shows the container is running (e.g., Up X minutes).
If the container is running correctly, select it from the list.
Click on Use as Data Source.
In the appearing window, enter the necessary connection details if not pre-filled. Click on Test Connection to ensure the connection to the MSSQL container is working properly.
After testing the connection successfully, click on Use Connection.
This will configure your DataFakery project to use the newly created MSSQL container as a data source.
