FAQ: Convert database between database types

• SQLite >>> Jet / MS Access
  Jet / Access engine has better performance for multiuser mode.
  
  
• SQLite >>> MSDE / MS SQL Server
  As a separate database engine MSDE / MS SQL Server will deliver much better performance. This is especially true for multiuser mode, big number of active users and for big databases.
  
  Attention: Support of MSDE / MS SQL Server database engine is a separately licensed powerDOCUMENTS option. Before converting your data to MSDE / MS SQL Server be sure you've got a valid license including this option.

1. Make sure nobody is using the database during the entire conversion process
   
   
2. Backup database and related files
   Make a backup of the database which contains your powerDOCUMENTs, the configuration and all related items.
   See "FAQ: Backup" for details on how to do this.
   
   
3. Download and run the conversion utility
   It can be downloaded from www.powerDOCUMENTS.com/powerdocuments-dbconverter-setup.exe. After download it will be extracted to a directory you specify and the conversion dialog will be started.
   
   
4. In the DB Conversion Dialog specify:
   

   ConversionType	Select "Convert database from one db-type to another (v4-format)"
   From DB, Type	This is the type of the database you are currently using. Typically this is "SQLite" as this is the default type powerDOCUMENTS uses after installation
   From DB, Path	Specify the path of the existing database containig the data to be converted. The default given will work fine for a default installation of powerDOCUMENTS. 'Path' is only to be specified for database types 'SQLite' and 'Jet / MS Access'.
   From DB, DB-Server	This specifies the database server in the format 'aaa\bbb' ('aaa' = Name or IP-Address of the server machine, 'bbb' = Name of the MSDE / MS SQL Server instance to use). The default specified will match the default installation of MSDE done by powerDOCUMENTS database conversion tool. 'DB-Server' is only to be specified for database type 'MS SQL Server'.
   From DB, DB-Name	This is the name of the database to use. The default specified will match the default installation of MSDE done by powerDOCUMENTS database conversion tool. 'DB-Name' is only to be specified for database type 'MS SQL Server'.
   From DB, DB-User	This is the name of the database user internally used for login to the database server. The default specified will match the default installation of MSDE done by powerDOCUMENTS database conversion tool. 'DB-User' is only to be specified for database type 'MS SQL Server'.
   From DB, Password	This is the password of the database user internally used for login to the database server. The default specified will match the default installation of MSDE done by powerDOCUMENTS database conversion tool. 'Password' is only to be specified for database type 'MS SQL Server'.
   To DB, Type	This is the type of the database you want to convert to. Typically this will be "MS Access" (converting to Jet / MS Access engine) or "MS SQL Server" (converting to MSDE / MS SQL Server)
   To DB, Path	Specify the path where the new database shall be created. This database must not already exist. If you want to overwrite an existing database you can delete it from the Browse-Dialog (But be carefull not to destroy valuable data) 'Path' is only to be specified for database types 'SQLite' and 'Jet / MS Access'.
   To DB, DB-Server	This specifies the database server in the format 'aaa\bbb' ('aaa' = Name or IP-Address of the server machine, 'bbb' = Name of the MSDE / MS SQL Server instance to use). The default specified will match the default installation of MSDE done by powerDOCUMENTS database conversion tool. 'DB-Server' is only to be specified for database type 'MS SQL Server'.
   To DB, DB-Name	This is the name of the database to use. The default specified will match the default installation of MSDE done by powerDOCUMENTS database conversion tool. 'DB-Name' is only to be specified for database type 'MS SQL Server'.
   To DB, DB-User	This is the name of the database user internally used for login to the database server. The default specified will match the default installation of MSDE done by powerDOCUMENTS database conversion tool. 'DB-User' is only to be specified for database type 'MS SQL Server'.
   To DB, Password	This is the password of the database user internally used for login to the database server. The default specified will match the default installation of MSDE done by powerDOCUMENTS database conversion tool. 'Password' is only to be specified for database type 'MS SQL Server'.

   After that you can start the conversion process by pressing the "Convert" button. Help is available via "Help" button or F1.
   
   Screenshot "Typical conversion from SQLite to Jet / MS Access":
   
   
   Screenshot "Typical conversion from SQLite to MSDE / MS SQL Server":
   
   
   
5. Adjust Configuration
   Make sure powerDOCUMENTS 2 is configured for the right database engine and has the correct database path or database access information. The configuration file of powerDOCUMENTS can be changed with the config dialog of powerDOCUMENTS (config keys: 'dbType' and 'dbPath' for SQLite and Jet/MS Access or 'dbType', 'dbServer', 'dbName', 'dbUser' and 'dbPassword' for MSDE/MS SQL Server database engine)
   
   When you are going to MSDE / MS SQL Server and you install / initialize MSDE from powerDOCUMENTS database conversion tool the initialization is able to adjust the configuration of the local powerDOCUMENTS installation. See " FAQ: Changing to MSDE / MS SQL Server database" for details.
   
   
6. Check the results
   Use powerDOCUMENTS 2 and have a look at the resulting powerDOCUMENTs.
   This conversion does not change any data. It simply copies the contents from one database type to another.
   
   
7. Make sure everyone is using powerDOCUMENTS 2 with the converted database.