Where is RBS Stored in SQL Tables?

[Angel]

We are migrating from 2003 to 2007 and even though we ran all the scripts to
check for consistency & ran the verify option on the migration script before
we started, as soon as we ran the actual script, we errored out due to two
resources with blank RBSs (not sure how this happens since you can't save the
Resources to the Res Pool without an RBS but I digress).

Anyway, we can't just open the Res Pool and fix those values now because we
were running into issues with the WSS upgrade and decided to just uninstall
2.0 and install 3.0. So alas, our only option other than restoring and
starting over is to go into the DB and manually fix the RBS codes for these
two resources. Doesn't sound like a big deal except that we can't find which
table & field the RBS is actually stored in.

So, does anyone know what Table & Field the RBS is stored in SQL???

 

[Paul Conroy]

Angel,

Changing the RBS values manually in SQL is likely to open another can of
worms. The data is de-normalised and resides across a number of databases,
so it's not just a case of adding a single value to each row.

Probably the easiest way around this would be to perform the migration again
having updated all RBS values first. If this is not an option I would
strongly suggest raising a premier support call with microsoft.

HTH

Paul
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com