Hi - My PC has MSDE installed on it and I'd like to install Express to take advantage of some new functionality in Express. The PC runs Windows XP Home Edition. Here are my questions:
1. Is it possible to have both MSDE & Express on one PC without causing problems?
2. How do I move databases from MSDE over to Express?
3. How will my query editor (Toad) know which SQL Server version to point to?
4. When setting up ODBCs will the two different SQL Servers appear there?
I have a hunch that this is a fairly basic thing so if there are any useful threads or websites on this topic that anyone knows about, please do post the links. Of course, any answers to the specific questions listed above would be greatly appreciated.
View Complete Post