Solved

ESXi 5.1: migrate from SQL Express to SQL

Posted on 2013-01-15
3
402 Views
Last Modified: 2013-01-15
Hi,

I would like to migrate ESXi 5.1 SQL Express to SQL.
Can I just shutdown SQL services + esxi, then detach database, reattach on SQL server, then change SQL connection string/ODBC?

Please advise.
J.
0
Comment
Question by:janhoedt
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
Stelian Stan earned 250 total points
ID: 38778581
Yep. You can detach the database from SQL Express and copy over to SQL server and attach it, then change the ODBC to point to the new server.
0
 
LVL 23

Expert Comment

by:Stelian Stan
ID: 38778584
Also make sure you have TCP/IP connections enable on your new SQL server.
0
 
LVL 118

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE)
Andrew Hancock (VMware vExpert / EE MVE) earned 250 total points
ID: 38778610
Yes, you can do this as migration method.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It Is not possible to enable LLDP in vSwitch(at least is not supported by VMware), so in this article we will enable this, and also go trough how to enabled CDP and how to get this information in vSwitches and also in vDS.
Last article we focus in how to VMware: How to create and use VMs TAGs – Part 1 so before follow this article and perform the next tasks, you should read the first article how to create the TAG before using them in Veeam Backup Jobs.
Teach the user how to use create log bundles for vCenter Server or ESXi hosts Open vSphere Web Client: Generate vCenter Server and ESXi host log bundle:  Open vCenter Server Appliance Web Management interface and generate log bundle: Open vCenter Se…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now