February 12, 2009, 07:28 PM
EndreCreating new "blank" PMF SQL database
I copied the pmf_datamart database into a new, empty database with the Import utility.
When I tried to create a time dimension from external table, I was getting message from PMF "failure dropping dimension table". I text searched the mainstreet application folder for this string and found it in the dim_loader_metadata.fex. Looks like it calls the database stored procedure pmf_drop_table.
..
Looks like, the MS SQL database import utility doesn't copy stored procedures, just tables and views. I can only see two stored procedures in pmf_datamart that I can copy easily to the new database. Is there anything else I should copy?
thnx
Endre
February 13, 2009, 09:16 AM
Bob Jude FerranteHi Endre--
Import will not work for many reasons; it does not copy SQL metadata between databases at all, which means a whole bunch of stuff will be broken. There are only two operational ways to create a new pmf datamart and both are even easier than import.
You can either:
- (SQL Server 2005+ only) Restore the pmf_datamart.bak backup into another database name. Make sure you change the file names for the data and log files on the Option tab after you have typed in the database name which you want to create during restore.
- (Any SQL Server) Execute the SQL script [drive]:\ibi\apps\pmfdbms\mssql_ddl\sqlmss.sql on any empty database to turn it into a PMF datamart.
February 16, 2009, 01:28 PM
MoogleHi Bob,
I've ran the mqlmss.sql on an empty database, and pointed the adapter to the same database. All objects were created properly, and PMF is now working as desired.
This issue is resolved.
Cheers,
Joey