Hi,
The only correct way to migrate an mssql database is to do a backup and restore, any other approach such as importing objects will never work correctly because you lose primary keys, constraints and default values.
See the article Moving and Installation of mojoPortal
Hope that helps,
Joe