Local to Remote Dataportal - Export

Local to Remote Dataportal - Export

Old forum URL: forums.lhotka.net/forums/t/4202.aspx


IMindZ posted on Tuesday, January 22, 2008

Hi,

I need to export some data from the local database to the remote by way of using the Business Objects  (from the local to the remote Dataportal).

Has anyone come across a similar requirement? I'd like any thoughts on this...

 

IMindZ replied on Tuesday, January 22, 2008

My solution so far revolves around the fact that inspite of being connected to the remote Dataportal, if the Dataportal_Fetch is marked [RunLocal] it can be made to fetch data from the local DB.

JoeFallon1 replied on Tuesday, January 22, 2008

When you fetch a BO from a database it is marked IsNew=False.

If you plan to Insert it to a different database you have to set IsNew=True.

If you can't set it directly, you can create a new kind of BO which reads the values from the original BO. When it is created, IsNew=True and then you fill in the values from the other BO.

You also need to add connection string information explicitly to the Fetch and Insert methds as you do not want to rely on some automatic mechanism which may point you to the wrong database.

Joe

 

Copyright (c) Marimer LLC