Granite WMS/Installation/Database

From Wikibooks, open books for an open world
Jump to navigation Jump to search

Granite database[edit | edit source]

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[edit | edit source]

  • 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 …)[edit | edit source]

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