cancel
Showing results for 
Search instead for 
Did you mean: 

Tranfser of database

Former Member
0 Kudos

Hi all,

Wishing you all a very happy new year 2006.

We have been making customisations for a client in production server at our end. Now all the testing is done and we need to deploy it at the client's deployment server.

How can we transfer this database so that dummy test data is not copied but customizations remain intact.

Pls guide.

Thanx

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

That can be a very useful tool. Which versions of SBO does it support?

and where can I find it? because I can´t find it in the web or the CDs

Former Member
0 Kudos

It should be in the SAP Folder: <i>C:\Program Files\SAP Manage\SAP Business One\AddOns\sap\CopyExpress\</i>

If it isn't there, you should contact SAP, or be a genius to understand the SAP-Maze (what SAP itself refers to as their user portal)

I did search for you, but the only thing I can find is the documentation for <i>Copy Express</i>: <a href="https://websmp101.sap-ag.de/sapidb/011000358700004445382005E.zip">https://websmp101.sap-ag.de/sapidb/011000358700004445382005E.zip</a> (Partner Login required)

Former Member
0 Kudos

I think is only for 2005 version.

Harold

Former Member
0 Kudos

Hi John,

Just for interest sake: I see there is a live expert session on copy express coming up on Monday 12 Jan. Go to https://websmp201.sap-ag.de/~form/sapnet?_SCENARIO=01100035870000000183&_SHORTKEY=011000358700006588...;

Hope it helps,

Adele

Answers (2)

Answers (2)

Former Member
0 Kudos

John:

I strongly recommend the CopiExpress add-on, that can be downloaded from SAP, or is in your Add-ons CD.

This addon can copy formatted searchs, user fields, master data, etc.

I only used once, but it was a very satisfactory test.

Harold Gómez V.

Former Member
0 Kudos

I recommend creating an add-on or stand-alone application that makes all the changes. This can be verified to be correct.

If your (database) customisations only consist of added fields or tables (so no fields/tables are removed), you can try to create a new database with the new structure (you can export the structure using the SQL server Enterprise Manager) and copy the data from one to the other (using the DTA data import/export wizard). Finaly delete the old database and rename the new database to the old name.

I usually use the last approach, but I don't need to tell you to make a backup before you begin, do I?