May 1, 2023 at 12:46 pm
I haven't been able to find a definitive answer via Google so I am hoping someone here can help.
We have a database on ProdServer. This database is log shipped to BIServer, and so is in standby/readonly mode on BIServer. I've been asked to replicate the database on BIServer to an Azure instance.
Is this possible? Or do we need to replicate the ProdServer copy?
May 2, 2023 at 7:59 am
It would all depend on requirements etc.
But you could use SSIS / ADF and ETL out the log shipped copy to Azure, custom scripting, BACPAC (if the DB size is small enough) etc
You couldn't use log shipping again or a form of replication as the database on the BIServer isn't in a state which will allow that to happen, so if you wanted to use log shipping or replication it would again need to come from the ProdServer.
May 3, 2023 at 5:44 pm
That's what I was thinking, thanks for confirming.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply