Solved

I need to Migrate SQL Server

Posted on 2014-07-22
3
126 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 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