ADMIN E3D - copy all inclueded DB's in project

We have many foreign DBs in a project "included" but now we need to "copy" them into the project.
Is there a way to do this work automatically? with Macro?

[LIST]
Collect all included foreign DBs
exclude them
create copy of them in the project

[/LIST]
Thank you

You have to go for RCF with sameref and same db number

For example i have tried for DB NO 7000

-*-*-*-*-*-*-*-*-*-*-**-*-*-*


FROM DB MASTER/PIPECATA
TO FILE /C:\temp\A1 /C:\temp\A2
RCFCOPY ALL
RECONFIG


EXCLUDE DB MASTER/PIPECATA
CREATE DB XYZCATA/PIPECATA-MAS CATA ACCESS MULTIW DBNO7000




FROM FILE /C:\temp\A1 /C:\temp\A2
TO DB XYZCATA/PIPECATA-MAS  
RECONFIG SAMEREF


-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

Unfortunately there is nothing available OOTB

I would export the project to Excel.
And transform the required spreadsheet page  into two  macros that you can run in Admin
The first one will exclude the foreign databases:

EXCLude DB Z/Z
EXCLude DB Y/Y
EXCLude DB X/X
(...)


The second one will "copy foreign" them.

COPY DB Z/Z FROM PROJ ABC US SYSTEM/XXXXXX TO Z/Z
COPY DB Y/Y FROM PROJ ABC US SYSTEM/XXXXXX TO Y/Y
COPY DB X/X FROM PROJ ABC US SYSTEM/XXXXXX TO X/X
(...)

Hope this make sense

Hello guys, thank you very much for your answers! I will try it and come back with my results.

Hey guys,
Please I have a question in the same context. Is it possible to copy a foreign DB and changing the DBNumber at same time?

maybe you should go with the reconfiguration as stated above, but instead create the DB number with the db number you wish to use instead of the same one.

i don't think we can copy foreign directly to a different DB number.

Hi!

Try this:

VAR !INCLUDEDDB COLL ALL DB WITH NOT UNSET(PROJID)
VAR !NAMEINCLUDEDDB EVALUATE NAME FOR ALL FROM !INCLUDEDDB
 DO !X INDICES !INCLUDEDDB

  $!INCLUDEDDB[$!X]

  VAR !PROJ Projid

  !BASEDEDADOS = AFTER('$!NAMEINCLUDEDDB[$!X]' , '*' )

  EXCLUDE DB $!BASEDEDADOS

  COPY DB $!BASEDEDADOS FROM PROJECT $!PROJ USER SYSTEM/XXXXXX TO $!BASEDEDADOS

 ENDDO


Attention: SYSTEM/XXXXXX could be different , check if it is the free user/password from the included project