September 16, 2008 at 6:53 am
Is there way to archive data from you sql database?
Thanks
September 16, 2008 at 6:59 am
generally consult your application vendor!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 7:01 am
It all depends of what you mean by "archiving".
You can certainly achive several different "archiving" strategies like...
- Have archiving partitions in your tables
- Have archiving tables in your database
- Have a separate archiving schema in your database
- Have a separate archiving database in your system
- BCP/XML out your data and move it to archiving tapes
- etc. etc. etc.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 16, 2008 at 8:25 am
its a databse with 5 tables , i want archive 2 or 3 years old data in to another database.
September 16, 2008 at 8:26 am
don`t have a vendor, the DB ahs 5 tables and i just wanted to archive some old data in to another db .
September 16, 2008 at 8:31 am
nabil nejat (9/16/2008)
its a databse with 5 tables , i want archive 2 or 3 years old data in to another database.
Cool!... just write a procedure and do it. What's the problem?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 16, 2008 at 9:40 am
looking for a script ?
September 16, 2008 at 9:44 am
nabil nejat (9/16/2008)
looking for a script ?
are you lazy or what? 😀 Script would be fully dependent of the structure of your tables, how could a general script solve such an issue? :hehe:
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 16, 2008 at 10:15 am
Write a procedure to do this, it should be fairly straight foward, do you have a date/time field to work out what the old data is?
post some more information about your table structure and some sample data, as i dont think you have given enough information to allow people to help.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply