Recreate database in v9.2 - sql server

Michael_Turek

Just curious - is there a way to rebuild the v9.2 Metastorm database (Sql Server)? Really I just want to clear out all data to get ready for the live conversion - since there's test data.  I know there are .sql sprocs in the install folder that have drop and create, but I would like to know instead of guess.

 

Also, how do I designate a starting efolderid? (ie if the last v7 efolderid is 0000000000000000000000000070000 - I would like to start v9 off at 0000000000000000000000000080000)

 

Thanks a lot

 

Jerome_Pearce

In our experience the simplest way is to drop the database, recreate it and rund teh create scripts again. That will lose all of your existing data (of course).

 

You do not need to worry about the folderid as it will be prefixed with 09. If you really want to change it, add the higher value (as an integer) to the eFolderId table when the engine is stopped.

Michael_Turek

Thanks Jerome - Any idea how to undo the 9 prefix and start with any desired folderid?

Jerome_Pearce

There is a field eFolderIPrefix in the eServer table. You need to change that. I am not sure if you need to specify a specific number of digits, but that should be explained in teh admin guide.

 

You would then need to add to the eFoilderId table as described to avoid conflicts with existing Folder Ids.