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 software fault?

818


Explain glossary of software qa/testing?

855


The Following Characterstics posses some XYZ company. * Uses formal standards and policies * Conducts software inspections * Has advanced configuration management and change control * Uses CASE tools * Has a software engineering process group * Gathers metrics on process and quality * Requires that developers have formal software engineering training * Practices continued process improvement Based on aboue , Tell me which CMM Level is the company..? 1. Level 1 - Initial 2. Level 2 - Repeatable 3. Level 3 - Defined 4. Level 4 - Managed 5. Level 5 - Optimizing

1938


HI friends, I am planning to take up foundation level ISTQB Certification exam in March. Anybody having the study materials and sample papers please mail sunkumaranr@gmail.com Thanks in Advance...

1847


Which is the easiest and preferred Automation Tool mostly for software Testing now a days? What is the reason for it.

1733


What is dynamic analysis?

815


How is an sql query executed in oracle 8?

869


hi,iam learning testing tools in mindq.i want to put 2+exp. is there any problem with that. tell me what are the Interview questions for experienced peopole. please give me the answer. thanq

2739


What is difference between SCSI-2 and SCSI-3 Standard?

1721


Evaluation?

774


What is test tools?

889


What is upwardly compatible software?

840


Hello Frds, Iam Going to attend Face to face interview on coming Monday in Wipro. Iam going with 3+ years of experience.I'm requesting u all of Frds who attended wipro recently pls post your interview experience, the questions they asked so that it will be help ful to me and other frds who are going to attend wipro.. thanks in advance

2858


How to test documents in a project that span across the software development lifecycle?

899


Explain unit testing?

824