Solved

ESXi 5.1: migrate from SQL Express to SQL

Posted on 2013-01-15
3
401 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
Teach the user how to edit .vmx files to add advanced configuration options Open vSphere Web Client: Edit Settings for a VM: Choose VM Options -> Advanced: Add Configuration Parameters:
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

743 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

15 Experts available now in Live!

Get 1:1 Help Now