Solved

I need to Migrate SQL Server

Posted on 2014-07-22
3
127 Views
Last Modified: 2014-08-06
I need to come up with the best solution to migrate SQL Server data from one service to another.  What would be my best approach
0
Comment
Question by:Idarac
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 16

Accepted Solution

by:
Dirk Mare earned 250 total points
ID: 40212368
Backup and restore the database.

Are you moving from the same SQL version to another or from older to newer or newer to older?

DirkMare
0
 
LVL 9

Assisted Solution

by:Lieven Embrechts
Lieven Embrechts earned 250 total points
ID: 40212777
in sql server enterprise manager, you can select the database, then in the tools menu you can backup the database.
in the new environment you can create the same login and restore the database.
then you have to let your clients connect to the new server. that's all.
0
 
LVL 1

Author Closing Comment

by:Idarac
ID: 40244947
Thanx to both of you.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql query with where clause 2 54
SQL QUERY 3 41
What is GIS method of Geometry data type? 6 28
SQL query 45 31
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

738 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