[Important] This procedure cannot be combined with a database upgrade to change versions. It is only intended to move an existing database to a new server using the same version of Uniprint. If you need to move and upgrade a server at the same time, either use the database migration tools (for upgrading to 8.0 or later) or install the older version at the destination and then upgrade the system.
Note: The collation order on the target SQL server (machine currently with no Pharos Database) must match the collation order on the current SQLserver. To check the collation orders, run the following query against each database:
select collation from syscolumns where name = 'name' and id = 1
Here are the steps to migrate your database between the two Pharos servers of the same version, using SQL 2000 Enterprise Manager: