Can SQL Server Express coexist with SQL 7/2000?
What is the order in which they are to be installed/uninstalled?
Yes you can but you will need the SQL Server 2005 developer edition which comes with management studio and cost less than $40 to manage all. If you really don't want to spend the money then you may need to upgrade the SQL Server 7.0 to 2000 so you will only access the SQL Server Express through command line. I am assuming you know there is no DRI (declarative referential integrity) in SQL Server 7.0 and SQL Server 7.0 uses TDS(tabular data stream) 70, while SQL Server 2000 uses TDS 80 and SQL Server 2005 Express uses TDS 90. If you are interested check out Provantage for the developer edition. Hope this helps.
http://www.provantage.com/microsoft-e32-00575~7MCSB0EX.htm
|||
So I assume that what you meant to say was that sans the graphical management tool (management studio), SQL Server 7.0, 2000 and 2005 Express can all coexist? Correct me if I understood wrong.
Regarding Management Studio for graphical management of SQL 2005 Express, yes I have downloaded and installed that for free.
What about the 2nd part of my original question - say I already have SQL Server 7.0 or 2000 in my machine. Will installing SQL Server 2005 Express have any repercussions? What about the other way round- SQL 2005 Express first, then SQL Server 2000?
|||You said you have installed SQL Server 2005 Express management tool, I am not sure you can use it to manage SQL Server 7/2000, if you can then you are good to go.
I must tell you I am not comfortable advising you to run SQL Server 7.0 without full management tool. If you are interested you can install SQL Server 7.0, 2000 and then the Express but also install the eval yes you can install all because I think the limit is seven in one box. The reason is I think it is ok to use express to deploy intranet application but I don't see it as a development tool. Hope this helps.
http://www.microsoft.com/sql/downloads/trial-software.mspx
No comments:
Post a Comment