Export to another fp database

[Marcel Verschueren]

Hello,

Is there someone who can tell me what's the best way to export records from DB1 to DB2 and after the data is export i will delete this data in DB1.

Every hour i will do the same but the data in db2 must be in place.

who can help me?

[spb]

Set up a one-line script in DB2 that will import from DB1, with whatever field mapping you need memorized. Call it "ImportDB1" or something.

Over in DB1, make a script that will isolate the set of records you need to export to DB2. After that records are found, include a script step of Perform Script. Select "External," navigate to DB2 and choose your new "ImportDB1" script.

I don't think you can export records directly into another db, but this way you are jumping to that db and importing the records. You can also include a delete found records script step after the Perform Script External, if you are sure it's working correctly. But I'd make this a separate little script attached to a button. After importing, make sure everything is in place in DB2, then click the delete button. Run it that way for a few days until you know it's working as it should be, then include the delete step in your export script.

If you don't want to end up in DB2 after running the external script, end your main script with some harmless step, like Go To Layout (SameLayoutI'mAlreadyOn), so that when the script quits, its final action takes place in DB12.

Steve Brown