Create a new database using sql scripts

<< 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.

 

SQLManagementConsole

 

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

 

WindowsExplorerSQLScripts

 

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:

 

DatabaseSetupForm

 

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