[rt-users] limited rt1->rt2 import

[Sherrill (Pei-chih) Verbrugge]

Matthew,

If you have a staging/testing server, you can copy limited data from RT1
dir and database over to the test server, install RT2 and run the import
script.  The transactions and each_req tables are what you should look
for.  You can copy over only few records of those two tables by using
something like "where serial_num < 100".  Make sure the tickets with
serial_num <100 are in ~rt/transactions/ dir.  Then it will just run
through that 99 tickets.  The rest of tables should be copied over
entirely for the conversion.

Sherrill


On Wed, 26 Sep 2001, Matthew Watson wrote:

> Heya.
>
>  I've previously asked about doing a date limited import from rt1 to rt2, as I didn't get any response, I guess its not that easy.
>
>  so.. second idea is to just not import the transaction data. eg , comment out the line ,
>  MigrateTrasactions($row->{serial_num}, $ticket);
>
>  this would speed up our test import hugely (as we have 7gb of transaction data) , but would rt2 have major errors if
>  there was tickets but no transaction data?
>
>  If that is no good, then I'll just comment out the MigrateTickets(); line to ensure our users and queues are going to be imported correctly.
>
> Regards,
> Mat.
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sherrill (Pei-chih) Verbrugge
spv at gospelcom.net

http://www.gospelcom.net
http://bible.gospelcom.net
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~