SQL Server 2005 Questions - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server 2005 Questions

Author

Topic

indy2005
Starting Member

12 Posts

Posted - 2007-08-21 : 17:45:33

Hello,

We are currently running a corporate client with Windows 2000 and .Net 1.1. We are running a number of SQL Server 2000 applications and are now thinking of upgrading to SQL Server 2005 as part of a data consolidation exercise. I am concerned on a number of points:

Can I connect to SQL Server 2005 using old ADO connectors? We have about 40 Excel VBA solutions, and we dont want to upgrade to SQL Server 2005 if we will be unable to connect to the data source. We cannot upgrade any new versions of MDAC or upgrade the .NET framework so this is a concern.

Do we need .NET 2.0 or Visual Studio 2005 to connect and work with SQL Server 2005? If so, this will be a problem as we cannot upgrade any client beyond .NET 1.1, and only have VS 2003 as a scripted application we can install for any development.

Has anyone have any experience of the KPI capabilities of SQL 2005? We are bordering on committing to a Business Objects BI platform, and having worked with BO Dashboard Manager and Performance Manager for 4 months (it was horrible), I am not relishing the prospect and would like to propose SQL 2005 as an alternative.

Many, many thanks

Indy

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-08-21 : 18:16:48

1. Yes.
2. No.
3. KPI?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-21 : 18:22:16

In BI, KPI usually stands for Key Performance Indicator(s).

E 12°55'05.25"
N 56°04'39.16"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-21 : 18:23:05

http://en.wikipedia.org/wiki/Key_performance_indicators

E 12°55'05.25"
N 56°04'39.16"

indy2005
Starting Member

12 Posts

Posted - 2007-08-22 : 05:04:15

quote:
Originally posted by tkizer

1. Yes.
2. No.
3. KPI?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

1.Yes

Can I check - will I lose any functionality such as use of new SQL features connecting through an old ADO connector. i.e. use of Pivots. I guess this is a backend operation, so should be OK.

2.No

Could you elaborate. I currently use good old fashioned DTS, SQl Enterprise Manager and SQL Query Analyzer. What client tools will I be be using to develop SSIS packages, and for general client access. DO we meet the pre-requisites for all these pieces.

Thanks

Indy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources