dataport to migrate customer table

pilar_martinez

Hi,

I need migrate to customer table data from other table from other database. If exists any dataport for this, please contact me.

Thanks

matttrax

You could probably use dataport 6706 if you don't have any custom fields on the customer table. If not you can easily add the fields to the dataport by going to view --> dataport fields while designing the dataport. But maybe you don't have access to that.

Savatage

1) try (Select all) copy->Open new database & paste into customer table. (are the table structures identical?)

2) use a dataport generator from the download section!
http://www.mibuso.com/downloads.asp?category=none

3) make your own
-a)Object Designer->Dataport
-b)New->Dataitem:Customer
-c)View->Dataport Fields
-d)View->Field Menu (Select ALL!)
-e)Edit->Copy (it should ask you if you want to add all the fields) YES!
-f)Save it in the 50000 to 59999 range
----ex. *Save 50000 - CustTableExport
Note: you can change the field seperators n such if necessary.

Then Export the file & import it into the new database.