3606 Moving SQL from 32 to 64 bit server

Please backup SQL server before making any changes. 

1. Open the SQL Management Studio Express.
2. Connect to your PDS database.
3. Expand the Databases by clicking the plus sign (+).
4. Expand PDS by clicking the plus sign (+).
5. Expand Tables by clicking the plus sign (+).
6. There are 3 tables, dbo.Folder, dbo.System_Parameter, and dbo.TemplateSet to modify.
7. Right-click on the dbo.Folder and select Edit All Rows or Top 200 rows.
8. Since you are moving from a 32-bit server to 64-bit the paths will change from C:\Program Files to C:\Program Files (x86). You will need to manually update the SQL database with the new paths. Note: The path to use is C:\Program Files (x86)\Calyx Software\PointCentral\filesync   
   
   Dbo.folder example. Column name is FolderPath
   1. Right-click on the dbo.System_Parameter and select Edit All Rows or Top 200 rows.
   2. Since you are moving from a 32-bit server to 64-bit the paths will change from C:\Program Files to C:\Program Files (x86). You will need to manually update the SQL database with the new paths. Note: The path to use is C:\Program Files (x86)\Calyx Software\PointCentral\filesync
   
   
   
   Dbo.System_Parameter example. Column name is vcValue
   1. Right-click on the dbo.TemplateSet and select Edit All Rows or Top 200 rows.
   2. Since you are moving from a 32-bit server to 64-bit the paths will change from C:\Program Files to C:\Program Files (x86). You will need to manually update the SQL database with the new paths. Note: The path to use is C:\Program Files (x86)\Calyx Software\PointCentral\filesync
   
   
   Dbo.Templateset example. Column name is Path
   There will be a column, Folder Path/vcValue/Path, in each table with the old folder paths listed.
   1. Replace the old folder paths with the new folder paths on all 3 tables. (Note: It is easier to copy and paste the path from Windows Explorer) So if the old path is C:\Program Files\Calyx Software\Point Data Server…. Change it to C:\Program Files (x86)\Calyx Software\PointCentral\filesync
   2. Then run the PointCentral configuration wizard to tell PointCentral to use Custom DNS instead of the Calyx Resolver Service.
   3. Then restart CalyxPDSFileSync Service and if all of the paths match up it will start up.
   4. You can watch the Event Viewer > Application Log for any errors or warnings from CalyxPDSFileSync.