![]() |
Telelogic System Architect (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() Answer: Thanks Duane. That's good to know. | |
![]() |
|
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.
|
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
Thanks Duane. That's good to know.
|
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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>ffice <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()> |
|
![]() |
|
![]() |
|
Hi I'm sorry but SQL 2005 is not yet supported. It will be soon though. ------------------------- Senior Software Developer Telelogic UK Ltd. |
|
![]() |
|
![]() |
|
Is SQL 2005 now supported with SA 10.6? Dave
|
|
![]() |
|
![]() |
|
It does not appear so, although I was told that it is.
We have tried it, but had no success. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.