InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 06:07:07 GMT20http://www.sqlservercentral.com/Forums/Topic1040105-148-1.aspxthank you..i'll try it..Tue, 28 Dec 2010 23:50:23 GMTvinayak.vhttp://www.sqlservercentral.com/Forums/Topic1040105-148-1.aspxhttp://www.mssqlcity.com/Articles/Replic/SetupTR/SetupTR.htmthis is about 2000 but you will get basic idea about transactional replication.Also if you search this website with your requirement then you will get plenty of useful information.Tue, 28 Dec 2010 23:45:22 GMTcrazy4sqlhttp://www.sqlservercentral.com/Forums/Topic1040105-148-1.aspxThanks for replying..i dont know about the transactional replication..i will try..is there any link for the transactional replication..so that i can find it ..Tue, 28 Dec 2010 22:43:46 GMTvinayak.vhttp://www.sqlservercentral.com/Forums/Topic1040105-148-1.aspxif both database are identical and you refreshing your database with live database by every 4 hrs then you can consider transactional replication.Orif you want your data also need to be updated on live database then peer-to-peer replication also there.Tue, 28 Dec 2010 22:25:19 GMTcrazy4sqlhttp://www.sqlservercentral.com/Forums/Topic1040105-148-1.aspxhi..i'm trying to retrieve the data from database using ssis package..database name is employee which contains 48 tables and it is around 20GB of memory.. it is a productiondatabase..now what i want is to retrieve the data for each four hours..i.e i want to execute the package for every 4 hrs..now what i did is i have taken a database transfer task and from thesource i.e production database i want to transfer to my databasewhich works fine..but what is the problem here is for every 4 hrs whole DB is replaced in my systemi've given overwrite TRUE..Here user enter the data into database for every 4 hour is minimum 10 MB of data..instead for replacing the whole database for every 4 hrs is there anysolution that what user enter data into database only that much amount of data should be append into my system.. is it possible please help me..Tue, 28 Dec 2010 22:14:05 GMTvinayak.v