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

Explain cyclomatic complexity?

628


What is software failure?

628


What is random/monkey testing?

586


What is qualification testing?

688


What is web application testing

1592






What is Multipath I/O?s

1611


What is functional decomposition?

624


We use the output of the requirement analysis, the requirement specification as the input for writing …

819


How will you log a Defect when you are in the process of executing a test case?

1676


What is test tools?

665


Can you test a program and find 100% of the errors?

570


What are the different methodologies in agile development model?

589


What is maintenance testing?

604


Explain how you would allocate a task to team members?

547


Explain what test plan is?

602