Just wondering what kind of processes you guys have for transferring production data offsite for analysis purposes?
I have read some of the literature but I am not sure of the overheads involved and the setup processes.
- Replication: With the production acting as both the distributor and publisher. I will employ a push system that updates my database on my analysis server weekly
- SSIS: No experience but seems to be the 'standard' way?
- Manual: Use windows scheduler to zip back my backup file and open up an FTP connection to my analysis server
- Mirroring: No experience but used more for high availability?
FYI, I am using SQL Server 2008 with Windows Server 2008 R2. MY DB is about 36 gigs. I am only interested in the data.
Other methods welcome!
*EDIT Additional information: I don't mind the database being read only and I am looking to run this process once a week.