Solved

I need to Migrate SQL Server

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

896 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

18 Experts available now in Live!

Get 1:1 Help Now