SQL Cloned Server Question

[TerryMcFall]

I'm attempting to clone our production servers (VM) into a test set and we're light on SQL support. Any guidance is appreciated.

The Rehost Guide goes over backing up the SQL server and restoring the database to the new machine, which is pretty clear. But before that, do I simply clone the SQL server then delete the database?

All of this will take place apart from the network so reconfiguring hostnames can occur before returning online.

Thanks,
-Ter

Terrence McFall
CAD Systems Administrator

Varian Medical Systems
911 Hansen Way
Palo Alto, CA 94304
650-424-6039 desk
650-799-0179 cell

[achukwuka]

I think all you need to do is export the db as instructed and then import it into the target selecting the option to "override existing database".

Alexius C. Chukwuka
IT Analyst, Global SAP Basis
Technical Change Management (TCM)
Deere & Company World Headquarters
400 19th St, Moline, IL 61265

[amansfield]

You need to install Oracle on your clone system. It has to be set up properly to run. Once you have done that then you import the database backup into it and then configure your cloned Windchill setup to point to the new database service.

Copying Oracle over and trying to run it won't work as there are registry settings, etc that have to be set up to make it work properly.