How can we maintain multiple source databases data in a single destination server database in SQL Server 2008? They all are at different networks, if that makes any difference.
Sql-server – Mirroring multiple source databases to a single destination in SQL Server 2008
mirroringsql-server-2008
Related Question
- Sql-server – Design SQL Server 2008 new install … which collation
- Sql-server – Microsoft SQL Server 2008 encryption over multiple DB versions
- Sql-server – SQL Server 2008 DB Performance on single disk
- Sql-server – standard way to use common data and procedures across multiple databases
- Sql-server – Maintaining multiple build versions of asp .net / SQL Server applications
- Fixing Microsoft SQL Server Error 1475 When Mirroring
Best Answer
Mirroring doesn't work like that. You can't bring multiple databases into a single database. You need to look to Replication, specifically Merge Replication as a solution for this. It can be set up across domains and it's specifically designed to take multiple different databases and bring them back to a single location. Mirroring is for creating a copy, a mirror, of a database. If you have more than one database, you'll have to maintain more than one mirror.