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 Can we use Multiple tables from Multiple databases in a same query? Yes. We can do it by writing fully qualified How to DELETE duplicate records from a table? Delete Duplicate records It is possible with CTE(Common Table How do you rename a table or column name? Rename The stored procedure sp_rename is used to rename 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.