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 |
|
rlaubert
Yak Posting Veteran
96 Posts |
 Posted - 2008-03-20 : 13:15:41
|
| I know SQL Express supports replication as a subscriber, but a company I may be going to has a bunch of SQL 7 servers that will be upgraded to SQL 2005. They are all small databases <200MB and I see no need for full versions of SQL. The only issue is they use replication to and from these boxes to corp every night. So from corp to the stores I would use replication. From the stores to corp I was thinking of using SSIS to pull the information or maybe a job to export the data and transfer it to corp. Was looking for other ideas. The communication lines for most part are high speed but they do have unexpected outages in different areas of the country so that is a consideration.Raymond LaubertMCITP:Administration, MCThttp://www.rd-webhosting.comHome Based Business Library and Hosting |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 00:16:25
|
| Do they require real time data sync? |
 |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2008-03-21 : 07:23:40
|
| No, sync once a day.Raymond LaubertMCITP:Administration, MCThttp://www.rd-webhosting.comHome Based Business Library and Hosting |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 17:41:59
|
| Then I'll go with ssis package. |
|
|
|
cbjroms
Starting Member
13 Posts |
Posted - 2008-04-07 : 10:40:58
|
| I have a similary requirement but would ideally need real time data sync. What would be the proposed solution?Thanks in anticipation.Chris |
|
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-04-10 : 10:26:26
|
| HiI am soon to be encountering a similar situation using SQL Server Express Advanced. Does anyone know if there is a guide available for replication. Also is there a way to do log shipping?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-10 : 23:22:01
|
| Take look at merge replication in books online. May not be able to do log shipping since sql2k5 express doesn't support sql agent. |
|
|
|
|
|
|
SQL Express Replication