Best way to copy a Metastorm database to a new server

[ssmelche]

I have two servers running Metastorm 7.5 and SQL Server 2008, one for production and the other for testing. What is the best way to copy the production Metastorm database to the test server?

In SQL Server  Management Studio, I did an export of the data from the Metastorm database on production to the Metastorm database on the test server. I found that I could not open any new folders or admin forms because the tables that had the prefix of "seq" had the IDENTITY property set to No for the eFolderNameSuffix column, but the same tables on the production server had the setting for IDENTITY to Yes for the same tables.

While I can now open admin forms and new folders after changing the IDENTITY property, I am concerned that there may be other differences between the production and test Metastorm databases that I am unaware of.

Would it be better to just do a backup of the production server's Metastorm database and restore it on the test server rather than just an export of the data in the tables?

[Ari Chopra]

I'm not an expert on this topic by any means, but I would think that you would be better off doing a backup and restore.  That will preserve all of the various table settings such as the identity column settings and so forth.

[Jerome҉]

I have to agree. Backup and retore is the only way - any other way will probably end in tears and be a lot more complex anyway.