Solved

I need to Migrate SQL Server

Posted on 2014-07-22
3
121 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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanx to both of you.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

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 …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

744 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

8 Experts available now in Live!

Get 1:1 Help Now