411 REFERENCE · Wikibooks
Granite WMS/Installation/Database
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
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]