Introduction
Installation
.. .. Technical Info
.. .. Network/multi-User
.. .. MS SQL Server

Upgrading
.. .. From v3 to v4
.. .. v4 to newer v4
.. ..To SQL Server

Navigation
.. .. Menus and Tabs

Inventory
.. .. New Item
.. .. List/View/Edit
  
.. .. Item Vendors

Assemblies
.. .. New Assembly
.. .. List/View/Edit

.. .. Assembly Types

Customer Orders
.. .. New Customer Order
.. .. List/View/Edit

.. .. Delivery/Shipping

Purchase Orders
.. .. Item Vendors
.. .. New Purchase Order
.. .. List/View/Edit 
.. .. Goods Receiving
.. .. Advanced

Works Orders
.. .. Introduction
.. .. New Works Order
.. .. Editing/Processing

Contacts
.. .. New Contact
.. .. List/View/Edit

Reports
.. .. MRP Shortage Forecast
.. .. Shortage Snapshot

Tools
.. .. Backup/Restore

 


Upgrading to the miniMRP Enterprise Edition.

 
The default install of miniMrp enterprise edition will continue to use the standard 'MS JET' database that was used by all previous versions of miniMRP.

However, miniMRP Enterprise Edition can also connect to an instance of MS SQL Server.

A separate migration tool is supplied to create the miniMrp database on SQL Server - described on the previous page

The rest of this page assumes that the SQL Database has already been created and that SQL Server is ready to accept connections.


When you use miniMrp Enterprise with the standard non-sql database you will see the version number and the text "enterprise edition" as shown in the image below.


 

 
In the lower left corner of the miniMrp program window is a Tools menu containing the "DataBase Setup" button.

Click that button and the Database Options window appears as shown here on the right >

 

 

 

When you select the option to "Use SQL Server Database" options appear allowing you to setup your SQL Server connection details.

It is assumed your server has been correctly setup and is waiting for connections.

 

 

 

 

If your connection test is successfull you can close the setup window and you should see that the main window of miniMrp now mentions SQL Server as shown below.