...
Setting up the database:
SQL server - this page will walk you through how to complete the database setup on an SQL server. This is the preferred database option.
SQL compact - this page will walk you though how to setup the database on an SQL compact file.
Migrating data:
Migrating the SNAPshot database to palCentre /wiki/spaces/PalCentre/pages/20709763 - this step needs to be completed if upgrading SNAPshot to palCentre. It only need to be completed once.
Migrating SQL compact database to SQL server database - this is only required for services that would like to move from SQL compact to SQL server.
...