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
 Managing database in SQL server 2008 from sql serv

Author  Topic 

PeeJay2583
Starting Member

40 Posts

Posted - 2011-05-11 : 05:32:11
Hi,

We have a database in SQL Server 2008 however my PC has SQL server 2005.

My question is that can we manage the database from sql server 2005 or do I have to install sql server 2008 on my PC to manage that database.

Please advise.

Thanks!

Mukesh Sajjan

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-05-11 : 05:35:51
you have to install SSMS 2008 but not the sql server.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

PeeJay2583
Starting Member

40 Posts

Posted - 2011-05-11 : 06:03:28
Thanks for the reply Webfred.

One more thing, will i not be able to manage from SSMS 2005.

Mukesh Sajjan
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-05-11 : 06:07:23
Try to connect your ssms 2005 to sql server 2008 and you will see.
Use ssms 2008 and you can also connect to older versions of sql server.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

PeeJay2583
Starting Member

40 Posts

Posted - 2011-05-11 : 06:18:33
Hi Webfred,

We are about to start a project wherein we will have our database in SQL Server 2008 as our organization has upgraded it to the new version.

Problem is I do not know as whether we will be able to connect it from SSMS 2005 and i cannot check it right now as I do not have access to that server yet, so I am doing some research before starting a project.

We are a big team and everyone use SSMS 2005, does that mean we all have to switch over to SSMS 2008.
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-05-11 : 07:30:22
Connecting from ssms 2005 to sql server 2008 will not work.
Install ssms 2008.
It is possible to install ssms 2008 on a client that has already installed ssms 2005.
There is no problem in coexistence.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2011-05-11 : 15:18:04
webfred - you can connect to a 2008 instance using the 2005 tools. However, the tools have to be upgraded to SP3 (I believe) and there are certain limitations to what can be done.

My recommendation is to install the 2008 tools side-by-side with the 2005 tools. You will still need the 2005 tools to manage any SSIS/SSRS projects in BIDS if you still have servers on 2005.

The 2008 (and R2) tools can access 2005 systems with no problems except for SSRS/SSIS projects. Again, for those you will still need 2005 BIDS to be able to modify and deploy those packages.

Jeff
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-05-12 : 01:45:37
Hello Jeff, thank you for the information.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -