|
<< Click to Display Table of Contents >> Navigation: Create Database > Create a new database using sql scripts |
If you are installing a new database you will need to open Microsoft SQL Server Management for Microsoft SQL Server 2005/2008 or Microsoft SQL Server Management Express for Microsoft SQL Server 2005/2008 Express.

Next, open your Windows Explorer to the CD --> Database --> SQL Scripts.

Run the .sql files in SQL Server Manager in the following order:
1.CreateDatabase.sql
2.CreateUserAccount.sql
3.CreateDataTypes.sql
4.CreateTables.sql
5.CreateViews.sql
6.CreateStoredProcedures.sql
7.CreateTriggers.sql
8.InsertsDefaults.sql
After you execute these files you can start using Rosistem Assets and setup your database connection.
At the first run of Rosistem Assets the screen appears:

Enter you server name, login ID, password and the database name to access the SQL Server.