What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    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?

  • Options
    volterificationvolterification Posts: 5 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
  • Options
    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.