Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hai
Yak Posting Veteran
84 Posts |
 Posted - 2007-11-28 : 12:00:46
|
| Hi All,What is the best way to transfer data from a web-farm to another server for web-report?Mirror?Replication?Daily Schedule job?Other?What are the advance and dis-advance of each type? thanks |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-28 : 12:03:23
|
| by best do you mean fastest, least overhead, easiest to maintain, most fault tolerant, etc? |
 |
|
|
hai
Yak Posting Veteran
84 Posts |
Posted - 2007-11-28 : 12:07:53
|
| I'm looking at least overhead, fastest transfer.thanks |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-28 : 12:15:10
|
| Do you need up to the minute data?If so then Mirroring will be your fastest, but the cost will tie in with this.If not, you may as well go for a daily schedule.If neither are feasible, then replication is your friend. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-28 : 12:23:14
|
| You can't use database mirroring for this since the mirrored database wouldn't be available until you ran the failover command. Once you run the failover command, production is now running on the mirrored server which isn't what you want.I'd recommend replication. You can modify the job so that it isn't continuous updates if you don't require continuous feeds.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-28 : 12:26:07
|
| you could1. use sql job on web-farm to bcp out the tables to text files2. another sql job on web-report to xcopy the files from web-farm then loan using bulk insertbcp/bulk insert are not pretty or informative, but they will be clean and quicktake a quick look at ssis before you decide though |
|
|
|
hai
Yak Posting Veteran
84 Posts |
Posted - 2007-11-28 : 15:52:54
|
| Thank everyone for the valuable input. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-29 : 01:46:40
|
| Why don't make db backup? Much easier than bcp. |
|
|
|
|
|
|
Best design transfer data between two server.