StrataFrame Forum

DB2

http://forum.strataframe.net/Topic1707.aspx

By Daniel Essin - 7/2/2006

With Sql Server prices going up and DB2 Express being free, bundling DB2 with my products could provide a competetive advantage.



What is the feasibility/difficulty of adding DB2 support? Is it something I could do with the source?
By StrataFrame Team - 7/3/2006

Yes, you can easily create a new DbDataSourceItem class for DB2.  You wouldn't even have to change the source, simply inherit MicroFour.StrataFrame.Data.DbDataSourceItem and implement it for DB2.  Your new class can then be added to the MicroFour.StrataFrame.Data.DataLayer.DataSources collection just like any other data source.  You can use the source for the SqlDataSourceItem class (found within MicroFour StrataFrame Base.dll) as a template for your own class creation.  As the actual data provider, you can use the classes within the System.Data.OleDb namespace with an OLE DB provider for DB2.  I believe DataDirect also has a good provider for DB2 that is completely .NET managed code.   Information:

http://www.datadirect.com/products/net/index.ssp

and

http://www.datadirect.com/products/net/matrix/dotnetmatrix.htm

Also, if you don't want to work with DB2, then you might consider just packaging SQL Server Express with your product since it's free.

By Daniel Essin - 7/3/2006

SQL Server Express is a good thought, but my understanding is that it still has a 2 gig limit. If that's not the case I would be more inclined to use it. Do you know what it's limits are?



Thanks
By StrataFrame Team - 7/5/2006

According to Microsoft, it has a 4GB limit on the database size.  Also, don't forget that since you can use separate data sources within StrataFrame, you can easily split your application across multiple databases and essentially double or triple your effective database size.

Microsoft's official info is here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx