Support Wikipedia

Sunday, October 4, 2009

Updating default database in Sybase version 9 and above

If multiple repositories are built in the same database platform and they all reside on the same server it's a good practice to check what the default database is, before installing or upgrading. 

Say for example you have Dev and Test repo set on <> server. If Dev repo is installed and now you would like to install Informatica in  Test repo. You would have to issue the following command to update the default database in Sybase.

For example in Rapid SQL...

login with uid to old repository database(say old is Dev)
sp_modifylogin uid,defdb, TEST
 sp_displaylogin uid

No comments:

Post a Comment