cancel
Showing results for 
Search instead for 
Did you mean: 

howto create database copy with only the newest data?

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks for the tip. I will try this.

markus_doehr2
Active Contributor
0 Kudos

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