Developing Awareim Application with existing SQL Srver table

sabbirehal

Hi Group,
I am a new awareim developer working on v7.1 right now, Just wondering if we can develop awareim application with existing sql server tables created for another programming application?

Thanks

johntalbott

Yes sir. See video https://youtu.be/EWFk3GpG_Jw and/or "connecting to external databases" section in the User Guide.

sabbirehal

thanks John, I will look this.

BLOMASKY

The GOOD news, is that it is easy to connect to external SQL databases. However, it depends on what you want to do with them. If you are just reading the data, all is good. If you plan to build a multi-user system and want to make sure 2 users do not update the same record at the same time, etc. then you will potentially have some issues.

You might want to try plan B, create an AwareBO with all of the existing columns (plus any new ones you want for relationships, etc.), let aware create the table, then shut down aware. Now look at both tables (your SQL one and you new one, add columns, alter the external table to match the Aware one, then rename them.

Any existing system that is reading the table wont know or care about added fields.

Bruce