SQL Server 2000 and 2005 1

[LonnieJohnson]

Can a person have Enterprise Manager and work with SQL Server and also have SQL Sever 2005 (not sure what the interface would be) on the same machine and bounce back and forth?

The reason I ask is because I want to do my production work on 2000 and do some testing on 2005 all on the same machine.

Thanks in advance.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[onpnt]

In short, Yes. You can have both instances running on the same machine as long as there are no name conflicts

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[gmmastros]

I have both versions (the developer versions) installed on my computer. I haven't had any problems.

If you already have sql 2000 on your computer, the install for SQL 2005 will be installed as a named instance.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LonnieJohnson]

Thanks for the reponses.

So I just go into EM and create an instance referencing the 2005 box?





ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[gmmastros]

No. When you install SQL 2005 (and the client tools for it), there will be the new 'SQL Server Management Studio'. It is Enterprise Manager and Query Analyzer combined in to the single tool.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LonnieJohnson]

Great. Where do I go to get the SQL 2005 (and the client tools for it)?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[gmmastros]

Call up Bill Gates and promise to give him money.

If you don't have the wallet (or patience) for this, you can download SQL Server Express (for free).

http://msdn.microsoft.com/vstudio/express/sql/

If I'm not mistaken, the developer edition costs approximately $50. A quick google search should find it for you. With the developer edition, you are not allowed to host a production database, but you can use it to develop your app.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[onpnt]

I like the Gates method myself

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[LonnieJohnson]

Thanks guys. I am up and rolling. I thank you much.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!