Moving data/databases between servers and databases in SQL Server

Ways of moving data/databases between servers and databases in SQL Server.

BACKUP/RESTORE,
Dettach/attach of databases,
Replication, DTS, BCP, logshipping,
INSERT...SELECT, SELECT...INTO, creating INSERT scripts to generate data
Different types of BACKUPs avaialabe in SQL Server
Full database backup. Differential database backup........
What is database replicaion?
The process of copying/moving data between databases on the same or different servers......
What are cursors in SQL Server?
Cursors allow row-by-row prcessing of the resultsets. Types of cursors: Static, Dynamic, Forward-only, Keyset-driven.......
Post your comment

Related Content

Follow us

▲