Source Control between two DBs

volterification

Hello all,

On my team we were trying to build a source control system that would pass by having one shared testing DB on server linked with one Prod DB on server. 

Is it possible to link two DBs from two different servers? what about from the same server?

DanC

Hi @volterification

I might need you to slightly elaborate on what you're asking, however, if you're just simply asking can you link two databases from two separate servers, then yes that's entirely possible by linking them to separate repositories.

volterification

HI @DanC, thank you for the reply.
What I wanted to connect would be server1.DB1 -> server2.DB2 (being the repository) but i guess its impossible.

would this other solution be possible:
both DB connected to the same repository like i show below?
server1.DB1 -> GIT(repository) <- server2.DB2

DanC

Hi @volterification

That would be fine, my advice would be to make sure you do "get latest" often to keep changes up to date and not making changes to the same objects.