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