StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Is it possible to shift completely to Oracle?

RE: Is it possible to shift completely to Oracle?

Ross L. Rooker, Sr. — Mon, 06 Feb 2012 09:25:30 GMT

Will the Securirt tables also be XML?

Is it possible to shift completely to Oracle?

lastcanary — Mon, 06 Feb 2012 09:25:30 GMT

StrataFrame has its own databases in SQL server. It is possible to move some of its tables out of their StrataFrame database and we managed to do that but our aim is to shift completely to Oracle.

Since our application is in Oracle, we would like to install StrataFrame database to Oracle and a new SQL server installation will not be required at all.

Is it possible to do that?

RE: Is it possible to shift completely to Oracle?

lastcanary — Tue, 06 Dec 2011 11:40:38 GMT

I am very excited about version 2.0!

I hope that the version will appear early in 2012

RE: Is it possible to shift completely to Oracle?

Trent L. Taylor — Tue, 06 Dec 2011 09:42:01 GMT

As I mentioned in your PM, and as Ivan has stated, this is not possible for the StrataFrame database. But for a peek into StrataFrame 2.0, all of the BO mappings, etc. will be stored as part of the project in XML (basically) files so that they support versioning, etc. without the need for a SQL Server database for the SF data.

RE: Is it possible to shift completely to Oracle?

Ivan George Borges — Tue, 06 Dec 2011 08:43:53 GMT

Not possible for your developing environment.

As for production, if you don't use the Role Based Security module, you can have only Oracle, otherwise, you still need a SQL Server for the security tables.