Granite WMS/Installation/Database

Granite database

Setting up the database entails executing various sql scripts against the database. These scripts will create the Granite database including default data. It’s recommended that you are familiar with the basics of SQL and have basic knowledge of executing a sql script.

Granite

• Open SQL Server Management Studio and Connect
• Open New Query
• Paste the content of GraniteDatabase_Create.sql into the query window
• Open menu Query and click SQLCMD Mode
• Review database name in script
• :setvar DatabaseName "GRANITE"
• :setvar DefaultFilePrefix "GRANITE"
• Click Execute or [F5]

ERP (Accpac, Pastel …)

• Open New Query
• Select the correct ERP database
• Paste the content of [ERPNAME]_Create.sql into the query window
• Click Execute or [F5]