What are the different ways of transferring data from one database to another database? Posted in SQL Interview Questions by Chandrasekhar Raparthi On April 16, 2014. 1 Comment There are several ways available to transfer the data from one database to another database. Few of them are listed below. SSIS BCP Import/Export Wizard INSERT…SELECT… SELECT…INTO… DTS 2000 Share this:GooglePinterestEmailTwitterLinkedInFacebook Tags:Data Transfer,SSIS Related Posts What are Magic tables? Magic Tables: Magic tables are the virtual tables provided by I have a table with 100 records. Now I want to generate INSERT statements with the same data. How will you generate? Open SSMS — Right click on Database — Tasks How to DELETE duplicate records from a table? Delete Duplicate records It is possible with CTE(Common Table Latest Comments April 30, 2014 Beverly Yes! Finally someone writes about information. Here is my homepage :: http://harvard.edu (Beverly) Reply Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Notify me of follow-up comments by email. Notify me of new posts by email. This site uses Akismet to reduce spam. Learn how your comment data is processed.