How to move database to other computer (MS SQL Server 2000 and MSDE2000 supported)

1. Install CliniView database to the new computer(destination)
2. Delete FMSTemplates directory from destination computer (e.g. C:\CVDATA\DB\Files\FMSTemplates)
3. Make backup from source database (e.g. "C:\Program Files\CliniView Database\Tools\BackupCVDB.bat")
4. Copy(replace) backup file from source to destination (e.g. C:\CVDATA\Backup\cvmsde.dat)
5. Copy all files and directories from source to destination (e.g. C:\CVDATA\DB\Files ALLCONTENTS)
6. Run Import patch as follow (on destination computer)

   CliniView 5.0 database installed to the destination computer:
             - ImportDB_CV50.bat

   CliniView 5.1 or later database installed to the destination computer:
             - ImportDB_CV51_NT.bat (Win2000/XP)
             - ImportDB_CV51_9X.bat (Win98/ME)

   CliniView database installed to existing SQL server (AdvSetup used)
             - ImportDB_CUSTOM.bat (patch-file shall be edited...see more information: How to customize patch-file)

   Import.sql and OSQL.exe must be on the same directory than patch-file


7. Reconfigure database connection(ODBC) of the client
   (client=all CliniView 5.0 or later computers)

Note: Be sure that nobody doesn't use CliniView before database connection has been reconfigured
      (otherwise all data will be saved to the old database)


How to reconfigured Database connection (ODBC)

To configure an ODBC data source

1. Click on the Start button, select Settings, and then Control Panel
2. In Control Panel, select Administrative Tools
3. In Administrative Tools, select Data Sources (ODBC)
4. Select the System DSN tab
5. Select 'Cliniview' and click Configure
6. Select the new server[\Cliniview] from list and click Finish


How to customize patch-file

1. Mouse right click ImportDB_CUSTOM.bat and choose Edit
2. Define administrator login id: SET USER=<login_id>
3. Define administrator password: SET PW=<password>
4. Define database server name: SET SERVER= <server_name[\instance_name]>
5. Define database server authentication Mode: SET MixedMode=<true\false> (false=only Windows Authentication used)
6. Save/Close patch-file

You can customize the patch-file if your administrator login = 'SA', password = 'SECRET',
server = CVSERVER\CliniView and Mixed Mode used (MS SQL Server installation)
by typing a command similar to this:

SET USER=SA
SET PW=SECRET
SET SERVER= CVSERVER\CliniView
SET MixedMode=true



