October 22, 2014 at 1:17 pm
Hi.
I have a database with all my customers data and I want to create other databases per customer that will serve just for read, reports and BI pourposes. These new databases will be in another server, each database should have only its customers data and I dont need to update it frequently.
Tks
October 22, 2014 at 4:24 pm
Backup, Mirror and Snapshot will always contain all the data in the database and won't let you filter just the data of one customer.
Moreover, snapshots can only reside on the same server as the source database, so they're out of question here.
What you can reasonably do is export the data with an ETL (SSIS to name one) using some custom logic.
Another possibility is a merge publication, using the customer as partition. The downside to this approach is the increased load on the publisher database due to merge replication triggers.
Personally, I would go for a custom SSIS package.
-- Gianluca Sartori
October 23, 2014 at 6:21 am
Is there any good article or tutorial that talk about ETL (SSIS)?
October 23, 2014 at 6:40 am
denisribeiro (10/23/2014)
Is there any good article or tutorial that talk about ETL (SSIS)?
You can search the internet for videos, whitepapers and articles about SSIS. But SQL ServerCentral has the stairways Stairway to Integration Services[/url] that could get you started.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply