StrataFrame Forum / StrataFrame Database Deployment Toolkit / Enhancement Requests / SQL 2008 Support / Latest Posts

RE: SQL 2008 Support

Ivan George Borges — Mon, 14 Jun 2010 10:45:26 GMT

And thanks, your priorities are going to the list. ;)

RE: SQL 2008 Support

Ivan George Borges — Mon, 14 Jun 2010 10:44:38 GMT

I know that XML and VARIANT were tried before and had som many truncation issues that the VARBINARY was used instead, and it worked far better. A VARCHAR field could also be used. So, when there are XML contents, we would create a VARCHAR (or VARBINARY if preferred) and store that XML content. Then to retrieve the XML content you can use an XMLReader once at client side.

RE: SQL 2008 Support

Keith Chisarik — Mon, 14 Jun 2010 10:23:13 GMT

In order: VARIANT*, DATE, TIME, XML

We don't plan to use FILESTREAM at this time.

*variant isnt new, but I am putting it in here as I would like to know how to use variant fields with SF, right now it is typed as a XMLReader in the BOMapper and I am not sure how to work with it in that form. It might be supported already, I dont know. I adopted variant as an alternative to XML field type for user customized fields as I figured that might be supported faster than XML

Thanks, I thank you for puting full support for SQL 2008 in the short list.

RE: SQL 2008 Support

Ivan George Borges — Mon, 14 Jun 2010 10:11:12 GMT

Hi Keith.

We are planning on releasing them and will allocate some time this month to look at them. This has been on the radar for a while and is already something the developing team planned to address, as you know. In our list of most pressing to least in regards to overall community impact, this item is close to the top and will be in there very soon. We will make sure you are the first one to know it when it is ready. ;)

One thing could help us all, could you please give me a list of the data types you are most interested in order of priority? FILESTREAM, for example, will require much more time and some business logic changes. So this one will not be in there the same time as some of the new dates, etc.

Cheers.

RE: SQL 2008 Support

Keith Chisarik — Fri, 11 Jun 2010 10:40:45 GMT

I am on the latest release and DDT still blows up tryiing to deploy DATE and TIME, also these dont have any default value selections in the DDT.

Can you please let me know what the status is on support for new SQL Server data types? Also would like to expand my inquiry to XML and variant datatype and if they are support and if so how they are to be used via BO Mapper, etc

Thank you.

RE: SQL 2008 Support

Trent L. Taylor — Tue, 02 Feb 2010 18:21:10 GMT

Nope. As we hashed through some of the emails that went around, this is on the list but we are hoping to have some pretty quick consecutive point releases that will include some more pressing matters. But we are already re-working the DDT and this is part of that process.

RE: SQL 2008 Support

Keith Chisarik — Tue, 02 Feb 2010 12:22:56 GMT

Not to hijack but, are the new data types supported in the latest release?

http://forum.strataframe.net/Topic25425-12-1.aspx?Highlight=sql2008

Thanks.

RE: SQL 2008 Support

Trent L. Taylor — Tue, 02 Feb 2010 08:53:30 GMT

StrataFrame supports SQL Server 2008, so I am unsure of what specifically you are referring to. Please elaborate, thanks.

SQL 2008 Support

David Kozikowski — Tue, 02 Feb 2010 08:51:47 GMT

Please ADD SQL 2008 Support