June 15, 2007 at 12:31 am
Hi,
I have a database that is constantly growing. I am opting to archive the data in the table to .csv file.
I there perhaps another way I can do this or is archiving it to a .csv file the only way. I am planning on doing it via DTS.
Is this a good idea?
Regards
IC
June 15, 2007 at 12:50 am
Why not considering to archive to a history table. By this way you ensure you have a table in your database that has history records and can be accessed whenever needed. The only disadvantage is it uses more space than your csv file.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 15, 2007 at 12:51 am
Hi,
You can have 2 databases:
1) Main (operational) with necessary ammount of data.
2) Historical. Created for collecting nonoperational data for further data analisys or recovery some necessary information.
This database can be hosted on slow hardware. Table data can periodically appended using ssis or dts tools.
Alexandr Volok
volok.blogspot.com
MCITP: Database Administrator
SQL Server Russian Group www.sql.ru
June 15, 2007 at 8:59 pm
agreed, better to keep historical data in another db, not csv. if it's in csv only, it's impossible to access it unless you load it into a db again. so why not just keep it there?
---------------------------------------
elsasoft.org
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply