Manually create a new SQL Server database

The simplest way to create a new SQL Server database is to use the New Database option in the application, but you can also create it manually and then open it with Promodag Reports.

To manually create a new SQL Server database, use the script provided with Promodag Reports. The name of this file is Repex.sql and you should find it in the application path (default is C:\Program Files\Promodag\Reports14). Caution : this script is used for the creation feature so do not change or move it.

To create a new SQL database follow this steps :

1. create the new database on the SQL Server. The easiest way is to use Enterprise Manager to do it.
2. launch Query analyzer, connect to the server and select the new database.
3. open the script Repex.sql found in the directory mentioned above and run it.

You should have some messages telling you that some records have been added. Your new database has now been created and you simply need to open it before starting to work with it.

See also: Using Promodag Reports and Microsoft SQL Server.

of