How to copy some tables in a DB to another DB in SQL Server



How to copy some tables in a DB to another DB in SQL Server..

Answer / mmehta

Using Import/Export data utility in SQL Server wizard.

Microsoft SQL server – Import/Export Data – next – Choose
From destination – To destination by selecting server and
DB – select Copy tables option – select tables- Run - Finish

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Testing AllOther Interview Questions

what is differnete between bug report@bugtracking

2 Answers   TCS,


In real time how you do the soak testing?

1 Answers  


What are the main bugs which were identified by you and in that how many are considered as real bugs?

1 Answers   TCS,


what are software related risks? give me an example.

3 Answers  


When you have logged a Defect for X, Y, Z issue. i)If X, Y issues are fixed and Z issue is not fixed. What will you do? ii)If X, Y, Z issues are fixed and a new issues T is created. What will you do?

1 Answers   Cap Gemini,


Whether networking knowledge is essential for a testing professional?

1 Answers  


Write a function Occurrences() in a language of your choice that takes in two strings. The first is a search string, and the second is a sentence. For example, running the function: Running Occurrences ("o", "Red Gate Software - Ingeniously Simple Tools") will output: Occurrences of 'o': 4 Occurrences ("at", "The cat sat on the mat") will output: Occurrences of 'at': 3 Sample Question 2: 2)Below is Notepad's File/Save dialog. a) If you were asked to test this dialog, how would you go about it? b) List various inputs you might place into the "File name" text field to test it.

1 Answers  


Hi, I am writing ISTQB foudation exam on 9 June 2010. Anyone please send me pdf of the book "Sample Exam Questions: ISTQB Certified Tester Foundation Level (Paperback)by John A. Estrella " to hsdantot@yahoo.com Thanks Sree

0 Answers  


What is a technical analyst?

1 Answers  


What is the role of quality assurance in a product development lifecycle?

1 Answers  


What is the key difference between preventative and reactive approaches to testing?

1 Answers  


If you find a design level issue, what you will do?

2 Answers   SumTotal,


Categories