A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.
We have a large MSSQL 2005 master database and serveral smaller operational data sources that feed from the master database. We are debating on whether to transfer data from that master database using SSIS or custom services. Can anyone offer any advise on how to decide between the given choices?
I believe that SSIS is an OK solution as long as we're doing a straight data transfer, but I prefer a custom application/service in those cases where we may need some business logic in the transfer process.
SSIS also allows you to do some processing, although I wouldn't recommend to creating anything too complex in SSIS. Simple (row) filtering is certainly doable.
If you foresee a lot of custom rules in the data transfer I would go for the custom services. Although I would probably also recheck my design, for ideally I would keep ODS data models as close as possible to the main DB data model, which should not require more than some filters in the data transfer.
Tuesday, September 25, 2007
This topic is archived. No further replies will be accepted.Other recent topics
Powered by FogBugz