asked on

Derby to MS SQL server Database migration for IBM director

Hi gurus

I have a couple of quick questions. I am trying to migrate an internal derby database to an external MSSQL 2005 database for ISD 6.2. It is for a customer and the customer has already created the database for the migration. I have the database owner permissions for the particular database instance and made me the owner of the database. But when I run the "cfgdbcmd.cmd -rspfile responsefile" it is asking me for the db admin password and my owner password does not work. I was just wondering if I need to be a database admin to be able to do this. Also another question, if there are more than one director server for the environment (for example one for each geographical domain) then does each IBM director server need one dedicated db instance or can all of them use one?

Thanks in advance.

ASKER CERTIFIED SOLUTION

Kevin Cross

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sinfuldips

ASKER

thanks a lot, I did figure out a way around this.
Thanks again, much appreciated.

Kevin Cross

@sinfuldips: was the way around this in my comment? If not, please post your workaround. It is probably best that is accepted as the answer also. I appreciate the points, but would rather see the PAQ contain a working solution if my post is not one. If it helped you in some way, but all means please include it in assist points. Anyway, if you would not mind, please post that as I am curious and it would be very helpful to future readers. You can then ask a Moderator to re-open this so you can accept the correct post.