StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



SQL 2008 SupportExpand / Collapse
Author
Message
Posted 02/02/2010 8:51:47 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 02/02/2010 9:13:18 AM
Posts: 2, Visits: 6
Please ADD SQL 2008 Support
Post #25723
Posted 02/02/2010 8:53:30 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 08/31/2010 2:36:53 PM
Posts: 6,287, Visits: 6,191
StrataFrame supports SQL Server 2008, so I am unsure of what specifically you are referring to. Please elaborate, thanks.
Post #25724
Posted 02/02/2010 12:22:56 PM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Yesterday @ 5:05:12 PM
Posts: 868, Visits: 39,095
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.

Post #25731
Posted 02/02/2010 6:21:10 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 08/31/2010 2:36:53 PM
Posts: 6,287, Visits: 6,191
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.
Post #25738
Posted 06/11/2010 10:40:45 AM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Yesterday @ 5:05:12 PM
Posts: 868, Visits: 39,095
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.

Post #27395
Posted 06/14/2010 10:11:12 AM


Strategic Support Team Member

Strategic Support Team Member

Group: StrataFrame Users
Last Login: Today @ 8:26:56 AM
Posts: 1,180, Visits: 13,405
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.

Post #27418
Posted 06/14/2010 10:23:13 AM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Yesterday @ 5:05:12 PM
Posts: 868, Visits: 39,095
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.

Post #27419
Posted 06/14/2010 10:44:38 AM


Strategic Support Team Member

Strategic Support Team Member

Group: StrataFrame Users
Last Login: Today @ 8:26:56 AM
Posts: 1,180, Visits: 13,405
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.
Post #27421
Posted 06/14/2010 10:45:26 AM


Strategic Support Team Member

Strategic Support Team Member

Group: StrataFrame Users
Last Login: Today @ 8:26:56 AM
Posts: 1,180, Visits: 13,405
And thanks, your priorities are going to the list.
Post #27422
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Trent L. Taylor, Steve L. Taylor, Dustin Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 8:34am

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.078. 8 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.