mjpolak/sqlservercp repository overview

⁠SQL Server database copy utility

It is dockerized utility that allows to copy database schema and data between two servers SQL Servers

It does not require sysadmin permissions, user only need to have GRANT-ed permission for database CONTROL.

⁠Why not use bacpac, bak?

Please read my question on stackoverflow: HERE⁠

If you know other soultion give me a message!

⁠Tested version:

⁠Docker

https://hub.docker.com/repository/docker/mjpolak/sqlservercp⁠

⁠How it works?

1. It uses sqlpackage⁠ to make dacpac containg schema of source database.
2. It uses bcp⁠ to save all source tables data.
3. Then, it try to publish schema via [sqlpackage] to target database, removing all non existing objects on target, and objects that are blocking migration. (All sqlpackage properties can be checked execute.sh⁠)
4. All data are removed from target tables.
5. Then bcp⁠ is used to bulk insert all data.

⁠How to use it?

⁠Enviroment variables

Image require to fill enviroment variables:

• SOURCE_DB_HOST= Source host
• SOURCE_DB_NAME= Source database name
• SOURCE_DB_PASSWORD= Source user password
• SOURCE_DB_USER= Source user name
• SOURCE_DB_PORT= Source db port
• TARGET_DB_HOST= Target host
• TARGET_DB_NAME= Target database name
• TARGET_DB_PASSWORD= Target user password
• TARGET_DB_USER= Target user
• TARGET_DB_PORT= Target port

⁠Docker compose

Easies way of running util is to copy environment config .env_template, fill all varaibles, save it as .env.

Then just execute docker-compose up