How to upgrade 2005 BIDS to 2008 BIDS

[KH75]

Hi

I have SQL sever 2005. I just want to update BIDS (SSRS,SSIS,SSAS) but not the complete SQL Server.
Is it possible? Please guide me how I can achieve it.

Thanks

 

[SQLBill]

Why? You should be able to do it, BIDS is part of the SQL Server Client Tools so you should just be able to get the SS2008 Client Tools and only install BIDS. But again - Why?

It is kinda backwards compatible, but you can't make use of the new features so why not just use SS2005 BIDS with your SS2005 database?

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[KH75]

Actually I want to create reports and ETL in SSRS/SSIS 2008 for learning. I have XP where I can find SS2008 Client Tools

Thanks

 

[fredericofonseca]

check here..

http://serverfault.com/questions/49924/installing-only-ssis-and-not-the-whole-sql-server-system

but remember that you need a license to use SSIS - it is not free

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[KH75]

Thanks

 

[KH75]

Hi

I uninstall my SQL server 2005 through control panel and try to install 2008 standard edition. when I click on setup file it gives me an err

[highlight #EF2929]Managed SQL Server Installer has encountered a problem and needs to close. we are sorry for the inconvenience[/highlight]

can you please help me. following is my machine information

Thanks

OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 3, v.3244 Build 2600
OS Manufacturer Microsoft Corporation
System Name QG-XP
System Manufacturer VMware, Inc.
System Model VMware Virtual Platform
System Type X86-based PC
Processor x86 Family 6 Model 42 Stepping 7 GenuineIntel ~2293 Mhz
BIOS Version/Date Phoenix Technologies LTD 6.00, 6/2/2011
SMBIOS Version 2.4
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "5.1.2600.3244 (xpsp.071030-1537)"
Total Physical Memory 2,048.00 MB
Available Physical Memory 535.52 MB
Total Virtual Memory 2.00 GB
Available Virtual Memory 1.96 GB
Page File Space 3.85 GB
Page File C:\pagefile.sys