Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Howto create an Empty Database ?

install
database

Hi,

after install without database if I use CounterSoft_Gemini_v4_1_SampleDatabase.exe a database with sample projects is create.

Howto create a database without sample ?

Regards Paolo
dcube
· 1 		dcube
Wednesday, September 7, 2011, 12:29:53 PM
Replies (3)
helpful
1
not helpful
ANSWER

You can either delete all projects via Administration -> Projects or run the create_tables.sql script. Note that it will remove all data including users. The defualt log in will be admin/admin.
Mark Wing
· 9108 		Mark Wing
Wednesday, September 7, 2011, 1:02:00 PM
helpful
0
not helpful

Hi Mark,

Thanks for the reply.

There are also other script, should I use them ?

CreateProcs.sql CreateProcsSQL2000.sql CreateTables.sql Create_Views.sql Drop.sql

If yes, which ones and in what order?

First of all I have to create the database with SQL 2008 tools then run the scripts, right?

Thanks in advance for answers.

Paolo
dcube
· 1 		dcube
Wednesday, September 7, 2011, 1:23:13 PM
helpful
1
not helpful

Yes, if you are creating a new database then you will need to run create tables, views and procs in that order. procs2000 shouldn't be run.
Mark Wing
· 9108 		Mark Wing
Wednesday, September 7, 2011, 1:28:17 PM