These pages cover SQL Clone 1, which is not the latest version. Help for other versions is also available.

Skip to end of metadata
Go to start of metadata

SQL Clone has the following elements

  • A web application (SQL Clone Server)
  • A SQL Server configuration database
  • Agents
  • File store
  • PowerShell cmdlets

The web application (SQL Clone Server) is installed on a single server and will need to access the configuration database on a SQL Server. The application is used to create and delete images and clones, the state of which is held in the configuration database.

An agent is required on each machine that hosts SQL server which will be used to either take an image of a database or create a clone of a database. The same agent can be used to perform either function.

Images are stored in the file store. The “differences” files for a clone database are held on the SQL Server and refer back to the image files stored in the file store.

 

Before installing the application you should consider:

  • Which SQL Server will host the configuration database, credentials with the appropriate access will be required by the application

  • Where clones should be stored – by default clones are created in the agent users local AppData folder. Changing this value applies to all clones created by that agent.

 

 

  • No labels