Creating a sample MS SQL Server database

First, you need to create an instance for sample game database. For this, one of MS SQL Server 2000, 2005 and 2008 must be installed. Available on MS SQL Server 2005 and 2008 Express Edition. You can download these programs from Microsoft official website.

Once MS SQL Server is installed, you need to create the database instance whose name is same as the sample that is going to be used. The table below is about database name per each sample & the location of the relevant DB schema.

Sample Database DB Schema Path
CasualGame2 ProudDB2-Test <installed folder>/ProudNet/Samples/DbmsSchema/ProudDB2
Log-Test <installed folder>/ProudNet/Samples/DbmsSchema/Logon&DBLog
DbLogViewer Log-Test <installed folder>/ProudNet/Samples/DbmsSchema/Logon&DBLog
RealtimeSocialVille ProudDB-Sng <installed folder>/ProudNet/Sample/RealtimeSocialVille/SngDb
SimpleAdo ADO_Test2 <installed folder>/ProudNet/Samples/DbmsSchema/SimpleAdo
SimpleAdoImage Ado_ImageTest <installed folder>/ProudNet/Samples/DbmsSchema/SimpleAdoImage
SimpleAdoMysql prouddb-test <installed folder>/ProudNet/Samples/DbmsSchema/SimpleAdoMysql
SimpleAdoXmlField test <installed folder>/ProudNet/Samples/DbmsSchema/SimpleAdoXmlField
SimpleDB2 ProudDB2-Test <installed folder>/ProudNet/Samples/DbmsSchema/ProudDB2

SQL Network setting of Server 2005 , Setting SQL Server 2008 Network should be done in case of SQL Server 2005 version or a version over SQL Server 2005.

And then, you need to install DB Schema.

  • Create the database instance that sample uses first and if not familiar with SQL Server, please ask Nettention Technical Support.
  • As referring to the table above, create DB schema by executing each .sql file.

When you complete creating a database as guided in above, you may be able to see the following format.

db_sample_schema.jpg
Example of sample database installation completion (SQL Server 2008)