Solved

SQL 2005 Two Engines on Server Mgmt Studio

Posted on 2011-09-18
2
322 Views
Last Modified: 2012-05-12
I've got two Database Engines inside a single Server Mgmt Studio.  How can I move data from one database engine to the other?
0
Comment
Question by:dastaub
2 Comments
 
LVL 25

Expert Comment

by:jogos
ID: 36558286
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 500 total points
ID: 36558358
Using the Import and Export Wizard. Right click on database=> Tasks=> Import Or Export  and follow the friendly steps
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In this article I will describe the Backup & Restore 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.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

929 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

9 Experts available now in Live!

Get 1:1 Help Now