need to use a different database

Greetings,

I need to use a different MediaBin database than the one I selected when installing the Assest Server. Is there a way to do that, in Enterprise Manager?

The SQLServer 2000 database being used now is "MediaBin Repository2", but I need to use "MediaBin Repository".

Being that it is a SQL Server database, would it be a matter of detaching and renaming the databases, or is there a way in Enterprise Manager to select a different database?

Thanks!

Jim

Find more posts tagged with

Comments

jrMugz

OK, I found that in order to switch to a different database, I need to uninstall and reinstall MediaBin Server, and then choose that database.

What I need to do though, is then use a database and images that were copied through a different server. This must be where changing the MBSettings tablse comes in.

Any tips for this process would be greatly appreciated.

Jim

msrinivas

OK, I found that in order to switch to a different database, I need to uninstall and reinstall MediaBin Server, and then choose that database.

That is not true AT ALL. I would strongly recommend that you hire a consultant or contact Interwoven CSO or at least Interwoven Support to get this accomplished. I am not sure how familiar you are with administering MediaBin but from your posts it seems very less. This is something CSO/Support does very often for customers.

jrMugz

That is not true AT ALL. I would strongly recommend that you hire a consultant or contact Interwoven CSO or at least Interwoven Support to get this accomplished. I am not sure how familiar you are with administering MediaBin but from your posts it seems very less. This is something CSO/Support does very often for customers.

First of all, we are bringing in an expert for the migration, and we are just trying to get a heads up on the process for the future, by practicing with a small amount of test data on two dummy machines.

Regarding changing the database, in the Enterprise Manager when you go to the databse tab, you are not permitted to change it.

I consulted the help guide for Enterprise Manager. It said

"The ODBC information is set during the MediaBin installation process. You can modify this information by re-installing MediaBin OR by running the MediaBin System Administration Control Panel applet."

In the server re-installation, databases can be chosen, or a new one created. So I do not see how you can say that I do not "AT ALL" understand.

I came here for information and/or clarification on the product that we purchased. I would appreciate if you can answer in a little more respectful manner. If I misread your tone, then please accept my apologies.

Jim

msrinivas

I am not the one that wrote the documentation but I have first hand experience of not being successful at uninstalling and reinstalling it. The better approach is using the administrative applet. You will have to create an ODBC connection before doing that and make the new DB as the default in that ODBC configuration.

I am assuming you have a sandbox and dummy data that you are playing with. If you have a consultant coming in then my strong suggestion is that you just sit back, relax and enjoy the ride Smiley Happy

jrMugz

I am not the one that wrote the documentation but I have first hand experience of not being successful at uninstalling and reinstalling it. The better approach is using the administrative applet. You will have to create an ODBC connection before doing that and make the new DB as the default in that ODBC configuration.

Is there any documentation that you are aware of regarding how to create/use the administrative applet? The link they suggested I click on in the Help, only talked about clustering.

Jim

jrMugz

Here is another question. Say we detach the existing database, rename it as "MediaBin Repository_BAK", and then attach the MediaBin Repository saved to disk, from the other server. Then go into MBSettings and make the appropriate changes.

Would that work, as an alternative to going through the Control Panel applet, as far as the database goes, knowing that we will need to put the assets in the AssetDB folder as well?

Jim

lyman

The manuals are admittedly conservative in what they instruct for reasons or "warranty" (i.e., it is difficult for support to assist with installations that have been hand tweaked), but here are the basic concepts. If all you need to do is more from DB 1 to DB 2 and not move the application server the basic step is to make sure that the information in the registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\MediaBin, Inc.\MediaBin\Platform\CurrentVersion\Repository

is all correct. This means setting up a DSN connection and making sure that the connection parameters are modified (that is only relevant if you changed physical servers and not just databases).

The trick with the password is that if you enter a new password into the LocalOdbcPassword field in cleartext, at the next MediaBin server start-up it will encrypt this value, write the encrypted value into LocalOdbcPasswordEx and clear the LocalOdbcPassword field.

Not that I am in any way discouraging getting CSO involved! They will be able to run tests to make sure that everything is up and operating as it should be.

By the way, when in doubt check MBP.log for messages.

Cheers,

Lyman Hurd