1-866-278-6243
How to Migrate NumberCruncher All Orders to MS SQL
How to Migrate NumberCruncher All Orders to MS SQL
All Orders 3.X
Starting with version 3.1.18, All Orders, Sales Orders and Work Orders can use the Microsoft SQL Server (MSSQL) as the back-end database instead of the database engine presently used: Microsoft Access. However once you make this decision, there can only be ONE AND ONLY ONE Company File. No longer can the user open/switch to another NC Company File. In fact, as a general rule "Multiple NC Company Files" against one Quickbooks file is fully discouraged in all instances. The following is a list of frequently asked questions regarding switching to MSSQL:
What advantages does MSSQL have over Access?
-
Faster: When used over a network, our internal testing has shown that lists, entry forms and reports load up-to 400% faster. Note: Migrating will NOT speed up synchronization with QuickBooks.
-
More stable: Access databases are susceptible to 'Invalid database format' corruption issue.
-
Open: We do not disclose the password to our Access database whereas we do disclose the password to the MSSQL database. If you have MSSQL Enterprise Manager or are familiar with creating connections through code you can share data between NumberCruncher and other business applications. Note: It is not recommended that you alter the the NumberCruncher tables or view but you could add your own tables and views to the same database. top
No. We will provide you with the necessary utilities to set up your database and to convert the data yourself. If you want NumberCruncher to setup your database and convert your data for you, there is a charge of $450.00. top
Is there any change in the way the licensing works?
Yes. In the Access version your user list can contain more the number of licenses you own whereas in MSSQL your user list CANNOT contain more the number of licenses you own. For example, say you have a 5 user license but your user list (Edit - Users), contains 7 users. You will have to either purchase a 7 user license or delete 2 user from the list. Note: NumberCruncher will credit you for the users you already have so that in the above example, you will only pay for 2 additional users. Please see Ordering & Price Information for more details. top
Do I have to update NumberCruncher?
If you are using version 3.1.18 or higher then no, otherwise you have to update to the latest version. To view your latest version, within NumberCruncher do Help --> About. top
No - you do not have to have a server. You can designate one of your work stations to store the database files. This computer should have adequate processing power. The processing power should be more than would otherwise be required for Access. When a query is sent to Access over the network, the entire results set is sent to the work station where it is filtered. In MSSQL, the query is filtered on the server thus requiring it to have more processing power. top
No. You can install the Microsoft Desktop Engine (MSDE). MSDE is essentially a light version of MSSQL. According to Microsoft, MSDE has less storage capacity (1 GB). In addition MSDE does not come with the Enterprise Manager for viewing and creating tables. Although MSDE has less storage capacity than MSSQL, it should be adequate for NumberCruncher. Please see FAQ 113 for more details on installing and managing MSDE. top
NumberCruncher provides a utility for converting your data as well as setting up your users to point to the correct database. Please see FAQ 114 for more details. top
I don't use NumberCruncher over a network, should I migrate?
MS SQL may not provide substantial speed improvements when compared to a local Access database. However, If you have numerous items or transactions and you are experiencing delays in opening reports, you should consider migrating.
What is the future of NumberCruncher's support for Access?
Starting with version 4.0, NumberCruncher will not be using the Access database.
More questions?
Call to speak with a NumberCruncher Solutions Consultant at:
