Improve company productivity with a Business Account.Sign Up

x
?
Solved

ESXi 5.1: migrate from SQL Express to SQL

Posted on 2013-01-15
3
Medium Priority
?
425 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 1000 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 126

Assisted Solution

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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
Advanced tutorial on how to run the esxtop command to capture a batch file in csv format in order to export the file and use it for performance analysis. He demonstrates how to download the file using a vSphere web client (or vSphere client) and exp…
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…

608 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