Duplicating an Instance
If you wish to make an exact copy of the data from an adTempus instance (for example, duplicating the instance to a test environment) there are two approaches:
- Start with an empty database and use export and import to copy your configuration
- Copy the adTempus database
If you want to move the adTempus instance to a new computer, see Transferring adTempus to a New Computer.
Export and Import
Use export and import when you want to:
- Selectively copy data from one instance to another
- Merge data from one instance with existing data in another
- Keep configuration data but not job history
When you use this approach, be sure to review your settings in the Export Wizard to ensure that all the data you want is being copied.
With large amounts of data, a database copy will generally be quicker. If you are connected to an adTempus server older than version 6, note that export and import may fail when there is a large amount of data, especially if you include job history data.
Database Copy
Copy the adTempus database when you want an exact copy of all configuration data and job history. You can copy the databse using one of these approaches:
- Use the Copy Database tool in SQL Server Management Studio
- Create a backup of the database using SQL Server Management studio or another tool, then restore it to the same database server using a new name
- Create a backup of the database using the adTempus database utility, then restore it using the Database Configuration Wizard.
- In the Database Configuration Wizard, select the option to copy your existing database. This performs a backup and restore to copy the database.