Note: Creating SQL databases requires a certain amount of knowledge and the ability to create schemas for the database. For this reason it is best to have your system administrator handle all database conversions.
It is possible to create a new database using an existing database as a template. You can make a copy of a database with another name and database code and therefore create a unique database that has the same content as the original database.
You can create a new database based on a template as follows:
(Ensure that SQL Server Tasks is selected! See: SQL Server Tasks)
1. Start the Database Manager. See Database Manager.
2. In the list of databases that is shown, select the database you want to use as a template.
3. Select the Create database from template option or choose the File > Create Mavim Database From Template > Create Mavim database in SQL from template menu item.
The following dialog will appear:
4. Enter the appropriate details for your SQL server
5. Click the Options button and enable the necessary security options to make a connection to the SQL database possible.
6. Enter a new or different Database Code.
7. Use an external log database if needed. See Database Log.
8. Click OK. The database will now be created and you will return to the Database Manager.
