Personally instead of using SQL Server, I use PostgreSQL because it's faster and cheaper (open source).  It also takes significantly less resources (I run it right on my SAGE 100 server).  To replicate the data, I wrote a program that allows you to replicate the table structures in PostgreSQL and then allows you to define how frequently you want each table updated.  Once the auto-replicate mode is selected, it runs continuously updating the tables once they have "expired" per your settings.  I have no problem sharing the source code.  It's a .NET program, though I wrote and compiled it in Sharp .NET, because it too is free and open source.

Personally instead of using SQL Server, I use PostgreSQL because it's faster and cheaper (open source).  It also takes significantly less resources (I run it right on my SAGE 100 server).  To replicate the data, I wrote a program that allows you to replicate the table structures in PostgreSQL and then allows you to define how frequently you want each table updated.  Once the auto-replicate mode is selected, it runs continuously updating the tables once they have "expired" per your settings.  I have no problem sharing the source code.  It's a .NET program, though I wrote and compiled it in Sharp .NET, because it too is free and open source.

I would be interested in taking a look if you want to share.