Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vinu
Starting Member
34 Posts |
 Posted - 2010-12-29 : 00:12:25
|
| hi..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.. how to do it.. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-29 : 01:38:47
|
| You can use log shipping but the destination would be read only.Another option is transactional replication but that has quite a large admin overhead.Why are you using SSIS?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
vinu
Starting Member
34 Posts |
Posted - 2010-12-29 : 01:49:14
|
| thanks for replying..is there any way other than SSIS.. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-29 : 02:04:21
|
| I think you are transferring the database objects.Backup the source database, transfer the backup file and restore it.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
vinu
Starting Member
34 Posts |
Posted - 2010-12-29 : 02:33:03
|
| no i'm not transferring the database object..i'm just trying to append the datato the existing database what user have entered in the 4hrs schedule..instead of taking whole 20GB backupi want to append the data for every 4 hrs.. |
|
|
|
|
|
|
Taking Database backup for every 4 hrs in SSIS