Using SQL Compare to generate DB in Docker

MrBaasMrBaas Posts: 2 Bronze 1
edited September 29, 2017 8:33AM in SQL Compare
Hey.

We're creating Docker containers with sql server on them, and we want the docker containers to fetch all databases from GIT and create them. However, we can't find a good solution to this.
We are now looking at running t-sql statements to create empty databases when containers are built, and then sync the databases with sqlcompare tool from host to docker-container. But SqlCompare is not able to sync/deploy databases when "stored procedures" have referances to other databases, e.g:

{
USE [DB1]
CREATE PROCEDURE SomeProcedure
...
From DB2.dbo.SomeTable
..
}

In our case DB1 and DB2 are both referencing each other, so we can't create them in a manual order.

Is there a flag in SQLCompare that can ignore checks on other tables ?
Maybe there's another way of doing this that we're not seeing.. Any help would be great!

Thanks

Answers

Sign In or Register to comment.