Credit Hound versions up to and including v4.82 allow users to configure the back-end database in one of two formats, MS Access (mdb) or SQL server.
MS Access databases were recommended for clients with fewer than 1000 accounts or 10,000 transactions. However, as your customers grow, these users may need to move to an SQL server solution.
In Credit Hound v5 and later, the MS Access database back-end is no longer supported at all and all Credit Hound company databases must be migrated to an SQL server before the installation of v5 can be completed.
To assist with this migration, Draycir provide a migration wizard, which is copied to the Program Files folder whenever Credit Hound is installed:
"C:\Program Files (x86)\Draycir\Credit Hound\SQL Server Migration Wizard.exe"
This utility will migrate any MS Access company database to a SQL server running on 32-bit operating systems.
If your SQL server instance is on a 64-bit operating system, this migration tool will fail because of an incompatibility with the MS JET4.0 tools used to manipulate MS Access mdb files.
To migrate the data on a 64-bit operating system, Draycir have released Credit Hound v4.9 which includes 64-bit compatible tools to manipulate a .mdb database.
|Operating System Architecture
||Credit Hound version using MS Access back-end
||up to and including v4.82
||Run the SQL Server Migration Wizard from the Program Files folder
||up to and including v4.82
||Install Credit Hound v4.90, run the Migration Wizard from the Program Files (x86) folder, then immediately upgrade to Credit Hound v5
Establish the bitness of your SQL server
Open SQL Server Management Studio and run the following SQL query
You will see either x86 for 32-bit, or x64 for 64-bit in the version string
If you have a 32-bit SQL server
Run the Migration wizard for all the companies you need to migrate and then upgrade the Credit Hound application to v5
If you have a 64-bit SQL server
The Migration Wizard for Credit Hound v4.90 uses the MS Access 2010 Redistributable (MS.ACE.OLEDB), instead of MS.JET40.
- Download and install the x64 redistributable from https://www.microsoft.com/en-gb/download/details.aspx?id=13255
- Run SQL Server Management Studio as an Adminsitrator, create a new Query and paste in the following code to set the parameters required to import the data:
EXEC sp_configure 'show advanced options', 1; RECONFIGURE with override; GO EXEC sp_configure 'Ad Hoc Distributed Queries', 1; RECONFIGURE with override; GO EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1 GO EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
- Run the SQL Migration Wizard
- Upgrade to Credit Hound v5+