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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between test matrix and traceability matrix?

832


What are the structure-based (white-box) testing techniques?

848


What is syntax?

782


What is the information that should be covered in test plan?

785


What are the Difficulties you found while testing your module ? plese give the possible difficulties.

2196


What are the main constrains of SCSI in storage networking?

1662


What is quality management?

926


Explain performance testing?

809


What is error-based testing?

821


What is execution?

778


Explain traceability matrix?

800


What is a test closure?

779


What is oo integration testing?

739


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.

2103


is manual testing enough for 2+ yrs,does it need any tools

2114