Best way to mirror SQL database of customers to our SQL database

Question

Best way to mirror SQL database of customers to our SQL database

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

r.ginus SSC Veteran Points: 279 More actions · Answer 1

Now mirroring is working I want to make the next step.

I want to use the mirror database to display data in a website, so the database must be readable. I read that this is not possible.I can only create a snapshot from it which is readable. Is this correct?
If this is, is there another way to 'realtime' mirror a database with read only possibilities?

Thanks in advanced.

r.ginus SSC Veteran Points: 279 More actions · Answer 2

r.ginus

SSC Veteran

Points: 279

September 28, 2018 at 3:32 am

#2007343

Anyone an idea to read a 'mirrored' database?

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 3

Readonly snapshots?
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-and-database-snapshots-sql-server?view=sql-server-2017

Travis Halsell SSC Eights! Points: 896 More actions · Answer 4

r.ginus - Monday, September 24, 2018 8:18 AM
Now mirroring is working I want to make the next step.
I want to use the mirror database to display data in a website, so the database must be readable. I read that this is not possible.I can only create a snapshot from it which is readable. Is this correct?
If this is, is there another way to 'realtime' mirror a database with read only possibilities?
Thanks in advanced.

Maybe look into transactional replication if you need realtime readable data. Note, this can be quite resource intensive as the log reader will constantly be scanning on the source database.

Johnson Welch SSCoach Points: 18773 More actions · Answer 5

Look at this, this may help you out.
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server?view=sql-server-2017
https://www.mssqltips.com/sqlservertip/2464/configure-sql-server-database-mirroring-using-ssms/

r.ginus SSC Veteran Points: 279 More actions · Answer 6

Johnson Welch - Monday, October 29, 2018 11:33 PM
Look at this, this may help you out.
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server?view=sql-server-2017
https://www.mssqltips.com/sqlservertip/2464/configure-sql-server-database-mirroring-using-ssms/

Hi,
Because it is not possible to access the mirrored database, it has no use to use the SQL 'mirror' technique or am I wrong?
If not, is the SQL server Always On the only way to use the data real-time of the mirrored (synchronized)?