April 19, 2011 at 4:19 am
The same structure of two difference databases are there. But A database having more data. We want to move the entire data from A DB to B DB. which method we will invoke and make a fast.
The methods are..
Backup and restore, Bulkcopy insert,Log shipping and so on...
April 19, 2011 at 6:15 am
1-Take a full backup and restore this database with different name
2-USE SQL Server IMPORT/EXPORT Utility
3-Write a simple ETL process in SSIS(SQL Server Inegration Services)
4-If these are simple tables then use
INSERT INTO DB2.<your schema>.table1
SELECT * FROM DB1.<your schema>.table1
Default schema is dbo
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 19, 2011 at 7:58 am
Thanks, the written queries are time taken the above said which is act fast and reilable....
Regards,
Muruges
April 19, 2011 at 8:30 am
1-Backup and Restore most reliable
2-Bulk Insertion fastest
you want to copy in 1 go there is no need of log shipping
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply