That would be the safest way to go.

OK. Then I will handle thos in the VS IDE and export the data to the tables in the app

Thanks again

If you only plan to have one RBS application, then that would work.  But as soon as you were to create your second application, then you would have a problem. 

Hi Trent.

I really appreciate all the help you and all the others here have given me to help me get up to speed on the framework. What I am thinking is that when I get back to retrofitting this application after go live, I may just move all the RBS tables into the application and set everything up using the app. Would that work?

When you get back to it you make make it more simple.  The SFS tables and the SFS views that are in your StrataFrame database are required for your application (minus the SFSprojects table).  But other than that they will be identical.  So if you are not using the DDT, you can have SSMS create the scripts for you and then deploy them that way.  I will be sure to update the help docs with the manual scripts.  Most people use the DDT....including us.  We too have a very deep understanding of SQL Server, this is not the point of the DDT.  The DDT is designed for deployment and making deployment much easier.  This is why the DDT has a wizard that allows you to just click which RBS project you are using, and it will bring in all of the data for your security project.  If you do this manually, well, it is going to be much hard to distribute your permissions, etc.  It doesn't mean that it is not possible, it just requires more elbow grease.

But I know what you mean about staying on schedule.  When you start back up, start with the RBS sample, it might speed things up since you are a strong developer and a sample may be all that you need.

Sorry. Didn't see you got beyond the activation part.

1. Make sure you can connect to the internet.

2. From the StrataFrame menu in VS select License Information to bring up the Activation Client.

3. Click the Next button and answer Yes to the "Are you sure you want to deactivate ALL of your MicroFour products.

4. Rerun the License Activation Client.

5. Enter you Microfour user account (not your forum account) ID (e-mail) and password.

6. Select the network adaptor you wish to bind to and press Next.

7. Select the items you wish to activate (RBS should be listed) and press Next.

8. You should see a "Successfully Activated!!" message.

-Larry

Well, I have given up on trying to integrate RBS into my app for now. I have too much stuff to work on so I can take this app live within the next week or so. I can deal with the discrepancies. I have my own set of utility programs that can create a working script (correctly - not like how SQL Server does it ) from a set of tables.

When I have phase 1 finished, I will revisit the RBS integration.

Thanks for all the help

I haven't upgraded to the latest version (1.6.6), but the link in my help file is to a script from 2006. There are no auditing tables in it, so looks like SF probably needs to provide a new script for the security tables.

OK - I finally did figure that one out. So I created a simple security based application with one form that called the maintenace form and got an error when I tried to save a new user saying that a solumn in my users table did not exist. So apparently the script provided to generate the tables in my database is not correct

Thanks for the assistance.