How to transfer the content of the Item Maintenance screen from one database to another

[mlbechard]

We have created another database on the same server. We would like to transfer the content of the Item Maintenance screen and its related screen (Item Vendor, Item Location) from the current database to the new one. I guess to better way is to use SQL statement, right? In this case, which tables are necessary?

Any help would be appreciated.

Thanks

 

[dgillz]

Well at a minimum I would do the following:

IMITMIDX
IMINVLOC
POITMVND
OECUSITM

This would get you the item, item location, vendor item and customer items. I don't know what version of SQL you have but I would just export these tables to the new database.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[jbelk11]

In addition to Don's suggestion above...you may also want to grab IMLOCFIL as that contains the locations found in IMINVLOC, which would be needed to use the Macola toolsets to see the values.

Also note that this will give you the master item data from the source database...but does nothing as it relates to the accounting side of things.

Jen

 

[mlbechard]

OK. Do I also need IMMATCST and IMCATFIL which respectively represent the Material Cost Type and Product Category in the Item Maintenance screen?

In the Item location, do I need the APVENFIL, HUMRES and IMLSMST tables?

What else do I need for the Item Vendor?

I do not need the accounting side. I just eventually be able to create a Sales/Purchase Order.

Thanks

 

[jbelk11]

Hi mlbechard....

We can certainly advise you on tables and what kind of data is stored there....but at this point, I'm wondering why you don't just do a backup and a restore to a new database? You would then have everything you need to be able to test just about anything?

Jen

 

[mlbechard]

We have to create a separate database for the sales in the USA. The title of some reports will change and we need a separate account journal. But all the products will remain the same. Restoring the database from the actual one is not good in our situation because all the sales, accounting, etc, will be copying which we do not want.

Thanks