Options
Source Control between two DBs
volterification
Posts: 5 New member
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?
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?
Tagged:
Answers
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.
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
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
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.
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?