Jump to content

Export to another fp database

This topic is 7569 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

This topic is 7569 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.