There are several ways of doing this. One can use any of the following options: - BACKUP/RESTORE, Dettaching/attaching databases,.......
|
Data Transformation Services is a set of tools available in SQL server that helps to extract, transform and consolidate data.......
|