We are using SQL 2005 express edition as database for an application and the same system is deployed at different locations on different machines. We want to gather all the information at one central location. all the systems in different locations are connected to each other either through LAN or VPN. DTS is not available in sql 2005 Express.We are using dot net 2005 as front end for the system. Please suggest an option to export the data from different copies of database to one(something similar to DTS).
Would really appreciate feedback on this..Thanks.