I have an ecommerce site where I have more than 3 million inventories which is to increase shortly to 8 milion. I'm using currently a single sql server 2005 database. Now what I would like to do is use 2 databases, one for inventory data and another
for the rest such as users, orders, etc.
All the data access is done by a WCF service which is accessed by the website.
What is the right way of getting data from both the databases, merging them before sending them to the web client.
Please let me know if you need any further info.
Thanks and regards