I want to transfer the data every day and also transfer old data that is already in database, to the other data base.There are several data base in different geographical location and I want to transfer the data from that to my machine data base. All the data base is using sql server 2008 R2 express edition . So i cant have the publisher option. so what to do??????????
thanks in advance