Re: Copy data from one database to another

Jose Torres answer works, but a more direct method is to write a little script like this:



<loop code=perl db=database1> %_put=%_loop; $_put{_amount}=1; put undef, "database2"; </loop>


thats it ;-) just copy this code into a baseportal page and call the url of this page to run it...

in this case both databases must have the same field names, if you have different field names you need sth. like this:



<loop code=perl db=database1> put ["Field1_database2", $Field1_database1, "Field2_database2", $Field2_database1, ... ], "database2"; </loop>


ok?