|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
DTS (Data Transformation Services) comes under Integration Service.DTS Import and
export wizard lets us to import and export from external data source DTS has two major components: -> DTP Data Transformation Pipeline -> DTR Data Transformation Runtime
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
There are lots of options available, you have to choose your option depending upon your requirements. Some of the options you have are: BACKUP/RESTORE, dettaching and attaching databases, replication, DTS, BCP, logshipping, INSERT...SELECT, SELECT...INTO, creating INSERT scripts to generate data.
Create Date
:
Wednesday, September 12, 2007
Tags
:
SQL,
INSERT,
SQL Server,
replication,
move,
databases,
servers,
RESTORE,
dettaching,
attaching,
DTS,
BCP,
logshipping,
SELECTINTO
Click here
to improve the Interview Question, Answer and other fields.