Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: SQL Server 2005 (Replaces MSDE)
Topic Summary: Are there any conflicts with SQL Server 2005 Express?
Created On: 28-Jul-2006 18:32
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Joel Ogden, on Monday, July 31, 2006 1:35 PM

Answer:
Thanks Duane. That's good to know.
 28-Jul-2006 18:32
User is offline View Users Profile Print this message


Joel Ogden

Posts: 9
Joined: 19-Jul-2006

Is anyone aware of any compatibility issues with Microsofts SQL Server 2005 Express, which replaces MSDE for local instanes of SA? I haven't seen anything discussed here on the forum, and would like to know.
Report this to a Moderator Report this to a Moderator
 29-Jul-2006 22:32
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

We've been testing SA 10.22 on both the MSDE and MS SQL Server 2005 without problems (not express through). We'll be upgrading to 10.4 at some stage and we don't foresee any problems. Basically the table structure doesn't change. The only issue I have had was one script I wrote to iterate through all databases and select the ones that had an SA_Properties table. I found that the full SQL Server worked fine but the MSDE didn't understand the ?.information_schema.tables clause. Basically the '?' replaced the database name with the one currently being looked at. Code below if you're interested.
create table #SA (table_name varchar(20)) exec sp_MSforeachdb 'insert into #SA select distinct table_catalog from ?.information_schema.tables where table_name=''SAProperties''' select * from #SA

Edited: 29-Jul-2006 at 22:33 by Duane Hennessy
Report this to a Moderator Report this to a Moderator
 31-Jul-2006 13:35
User is offline View Users Profile Print this message


Joel Ogden

Posts: 9
Joined: 19-Jul-2006

Answer Answer
Thanks Duane. That's good to know.
Report this to a Moderator Report this to a Moderator
 24-Nov-2006 15:46
User is offline View Users Profile Print this message


David Aden

Posts: 22
Joined: 20-Apr-2006

Actually, I tried to set up SA against a SQL Srver 2005 Express installation today and it did NOT work. Most of the errors seem to be on table validation -- some columns are supposed to have a default value of "0" but these appear in SQL Server 2005 as "((0))". I was hoping that setting SQL Server 2005 Express compatibility back to SQL Server 2000 would handle this, but so far no joy.

-------------------------

================
David Aden
Webworld Technologies, Inc.
703-750-2416
Report this to a Moderator Report this to a Moderator
 29-Nov-2006 14:15
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

We are testing against SQL Server 2005 and SQL Server Express as of now.
Expect an announcement for a release date, with this support, in the not too distant future.

Thanks Ian

-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 9-Jan-2007 19:29
User is offline View Users Profile Print this message


Brenda Roston

Posts: 7
Joined: 3-Nov-2005

Is there an update on using SQL Server Express?  I've heard a rumor that MS-Vista is not going to support MSDE but will support Express.

Thanks,
Brenda
Report this to a Moderator Report this to a Moderator
 10-Jan-2007 09:48
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

We intend to support SQL Express and the full SQL Server 2005.
In development we are using both of these platforms for testing at present.

Thanks
Ian

-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 10-Jan-2007 22:41
User is offline View Users Profile Print this message


Todd Davey

Posts: 2
Joined: 10-Jan-2007

I have been trying to setup SA on SQL Server 2005.
I have been able to get a Catalogue setup, but when I try and create a Professional Encyclopedia I get a variety of errors (as shown below) before it tells me that the encyclopedia has not been created.

Can any offer any suggestions?


<Entity> Table <Class> Column <Default Value> Property is invalid, value <((0))> should be <0>fficeffice" />>>

<Entity> Table <FromArrow> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Entity> Table <FromAssc> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Entity> Table <SeqNum> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Entity> Table <ToArrow> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Entity> Table <ToAssc> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Entity> Table <Type> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Entity> Table <PropType> Column <Check Constraint> Property is invalid, value <([PropType]=(2) OR ([PropType]=(3) OR [PropType]=(1)))> should be <([PropType] = 2 or ([PropType] = 3 or [PropType] = 1))>>>

<IdGenerator> Table <GroupId> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<IdGenerator> Table <NextId> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Relationship> Table <ID1> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Relationship> Table <Sequence> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Files_History> Table <Snapshot> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Files_History> Table <TimeStamp> Column <Default Value> Property is invalid, value <(getdate())> should be <getdate()>>>

<Entity_History> Table <Snapshot> Column <Default Value> Property is invalid, value <((0))> should be <0>>>

<Entity_History> Table <TimeStamp> Column <Default Value> Property is invalid, value <(getdate())> should be <getdate()>>>

Report this to a Moderator Report this to a Moderator
 11-Jan-2007 10:56
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Hi

I'm sorry but SQL 2005 is not yet supported. It will be soon though.

Thanks
Ian



-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 15-Mar-2007 16:39
User is offline View Users Profile Print this message


Dave Keifer

Posts: 8
Joined: 29-Sep-2006

Is SQL 2005 now supported with SA 10.6? Dave
Report this to a Moderator Report this to a Moderator
 20-Apr-2007 03:15
User is offline View Users Profile Print this message


Todd Davey

Posts: 2
Joined: 10-Jan-2007

It does not appear so, although I was told that it is.
We have tried it, but had no success.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.