on 01-23-2008 11:45 AM
Hi,
I would like to create a copy of a database with only the data of the last year until today. The size of the database is around 10GIG. Most space is used by 2 tables (around 95%). In both tables I have an datetime field. What is the best way to achieve this? I already tried to delete the data with sql but this was extremely slow.
Is it perhaps possible to tell the loader to only export a table from row xx?
Any suggestions?
Thanks in advance.
Hello,
you could use the loader "export columns" command.
With the demo data "HOTEL" I filtered the data form the city table like this
loadercli> export columns * from hotel.city where name like 'C%' data outstream file c:/test
Like this you could provide a filter for your date fields. You may test the SQL statement with Database Studio before.
Regards
Wolfgang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
By default this is not possible.
There exists products for this purpose to do that -(like TDMS from SAP) - they have to be licensed and bought though.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.