Solved

how to copy a table QA environment to my Development environment

Posted on 2014-04-01
1
433 Views
Last Modified: 2014-04-01
Hi, I am trying to copy the table of QA environment to the Dev. How can I do this, I surfed through google but could not find the answer for it.
0
Comment
Question by:Aparanjith
[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
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 250 total points
ID: 39969890
Assuming you have rights to at least "read" that QA table, Open your Development SSMS then connect to your Dev SQL Server, select the database where you want to put it then right click IT and under "Task" menu that pops up select "Import data" (I believe forth from the bottom) and a simple and easy to use wizard will pop up then go from there.
1

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

740 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