Database

Database

· Click on the Database in the left side of the screen or on the Database icon on the screen. Click on the Edit button to make changes in the existing Database.

· Page appears with the created Database where user can Create another Database or can Upgrade existing Data Base.

· User can also Test the Connection by Clicking on the Test Connection button.

· Click on Create Database for New Database.

· Proper Server should be selected form the list available. We select Sql Server.

· Click on Next and Enter the SQL Server Name, Login Name and Password.

· Also Enter the Database Name and Click Finish.

· User can also change Database once they are created.

· Click on Edit and then click on the icon Infront of Database Name.

· User can select any of the created Database and the same will appear in Database Name.

· User can Upgrade Data base by clicking on Upgrade Database button and Test the Connection by click on Test Connection button.

Type of Database Supported

· There are 4 Database supported in the Application. They are,

SQL Server

· Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network

Oracle

· Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.

MSDE

· Microsoft SQL Server Data Engine (MSDE, also Microsoft Data Engine or Microsoft Desktop Engine) is a relational database management system developed by Microsoft. It is a scaled-down version of Microsoft SQL Server 7.0

Cloud

· A cloud database is a database that typically runs on a cloud computing platform and access to the database is provided as-a-service. These Cloud Database are maintained by a cloud database provider. Of the databases available on the cloud, some are SQL-based and some use a NoSQL data model.

Note: Most commonly, SQL Server Database is used in the Planvisage Application.

Upgrade Database

· User can Upgrade the Database once the Database is Created.

· For Creating the Database Refer to this Example.

· After the Database is created, click on the Upgrade Database button to Upgrade the Database.

· A message will pop up to confirm the Upgradation of the Database.