Consolidate information held in a number of SQL Server Express Instances

Posted by user321271 on Stack Overflow See other posts from Stack Overflow or by user321271
Published on 2010-05-06T07:24:17Z Indexed on 2010/05/06 7:28 UTC
Read the original article Hit count: 167

Hi, I'm trying to determine the best architecture for creating an oData web service for information held in a number of SQL Server Express instances. The web service should provide a consolidated view of the data. All the SQL Server Express instances have the same DB schema. I was initially planning to use SQL server replication however as I understand it, SQL Server 2008 Express cannot be used as a publisher.

Any help or suggestions would be appreciated.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about architecture