Source Control between two DBs

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?

Tagged:

Answers

  • 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.

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our Help Center?

  • volterificationvolterification Posts: 4 New member
    edited August 20, 2021 3:04PM
    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
  • 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.

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our Help Center?

Sign In or Register to comment.