Hi Guys,
I am having no luck with this.
I am trying to copy all data from Session A/Database A to Session B/Database B.
The objective here is keep Session A/Database A functional/operational while I work independently on Session B/Database B.
I tried Copying Session A but it only copied the Session to the new Session B without any data.
I tried copying Database A, it only copied the data to the new Database B OK but it was under Session A....
Can I in fact do what I want to do?
If so, how please?

Regards & TIA,
Ian

Ian


You neglect to tell us one important piece of information - how are you trying to do this? EDBManager / your application / Delphi / Windows.

Also what does this "while I work independently on" mean? Does it involve structure changes?


Roy Lambert

<<The objective here is keep Session A/Database A functional/operational while I work independently on Session B/Database B.>>

A session is a connection to your databases. So you can have a remote session and local session both pointing to the same databases. You do not need to create a new session.

* Create a new database B
* Backup database A
* Restore the backup to database B remembering to check the "Restore Catalog from Backup" in the Selection tab.

You can now work independently on database B and use the Reverse Engineer Database task to compare the two databases.

Richard

Hi Roy,
In EDBManager.

I want to develop it along a separate line so it will have further
development.
Yes it will involve structural changes however I don't want to affect
the original which will continue.

Ian

Thanks Richard,
It will have ongoing development without affecting the original.
Ian

Partial success.
My thanks to Roy & Richard.
I did a Reverse Engineer.
It's not perfect however I got the structure and data over.  
The process doesn't allow for an index being created as part of a
constraint.

Onward....

Regards,
Ian