Hi,
I have VS 2005 running nicely with SQL Server Express. I have now been asked to trial SQL Server 2005, and wondered how I go about installing it. Do I need to replace the SQL Server Express, will it upgrade it, or can I have both up and running.
Please advise on best method for a seamless installtion and experience.
Upgrade SQL Express to SQL Server 2005
Hot Topic
- Row Order on View Results
- Connection handshake failed - easiest possible configuration
- How to calculate difference between totals of two group
- Parsing a text field value into more than 1 value
- Error in execute sql task
- Text in to Datetime Question
- Access 2003 extended property error
- FireEvent issues with Reporting Services
- XML Config files
- VB2005 can't connect to SQL Server 2000 file?
SQL Server
- SQL Cluster Servers
- VS2005 Beta2 - Send updated DataTable to SQL
- JDBC Support for Database mirroring
- default parameter values not updated
- Scheduled Job Not Working
- Log file - failed MSDE SP4 Installation
- Weird INSERT INTO SELECT results
- Border around page
- ERROR: A variable may only be added once to either the read lock list or the write lock list.
- Couldn't use and aggregate funtion on an another aggregate function
Upgrade SQL Express to SQL Server 2005
KarateChop
Jennifer Peters
You have a couple of options:
1) You can upgrade your express instance. To do this just pop in the new CD and go through the setup dialogs. When you get to the instance name dialog enter the name of your express instance. If it was installed as part of VS it'll be SQLEXPRESS. You can also click the "Installed Instances" button to see the name.
2) You can install the relational engine side-by-side with Express, you just have to specify a unique instance name during the installation. If you select tools (e.g. Management Studio, etc) you'll be presented with an upgrade dialog - just confirm you want to upgrade the Express tools to the tools you're installing.
Cheers,
Dan