Frequently Asked Questions

SQL Server Backup Restoration

• To restore the SQL Server version of vpiclist_lite on Windows, use SQL Server Management Studio to connect to your desired database server. Right-click on the "Databases" folder and select "Restore Database". Under "Device", click the ellipsis icon on the right-hand side to open the next dialog. On the backup devices dialog, click "Add" to open the file window. Select the backup file and click "Ok". On the main backup dialog, click "OK" to perform the restoration.
• When restoring using a TSQL script, the following command is recommended:
  RESTORE DATABASE [vPICList_Lite]
  FROM DISK = N'{path-to-downloaded-bak-file}' WITH FILE = 1,
  MOVE N'vPICList_Lite' TO N'{path-to-MSSQL\DATA-folder}\vPICList_Lite.mdf',
  MOVE N'vPICList_Lite_log' TO N'{path-to-MSSQL\DATA-folder}\vPICList_Lite_log.ldf'

PostgreSQL Backup Restoration

• To restore the PostgreSQL version of vpiclist_lite, either a Database Management tool like pgAdmin can be used, or the Windows pg_restore and psql commands. An existing database is required to restore the backup into, after which a new schema named "vpic" will be created:
  • To restore the PostgreSQL version of vpiclist_lite on Windows using pgAdmin, connect to the desired database server and create an empty database. Right-click the database and select "Restore". On the "General" tab, select "Custom or tar" with the Custom backup, and "Plain" for the plain backup. For the custom restore, under "Data Options", in the "Do not save" section, ensure "Owner" and "Privileges" are selected. Select the backup file, and click "Restore".
• When restoring using pg_restore or psql, the following command structures are recommended:
  • Custom: pg_restore.exe --host {your_host} --port {your_port} --username {your_username} --dbname {your_db} --no-password --no-owner --no-privileges --verbose {path_to_file}
  • Plain: psql.exe --host {your_host} --port {your_port} --username {your_username} --dbname {your_db} --file {path_to_file}

Parameters for spVinDecode procedure/functions