Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
iktheone
Yak Posting Veteran
66 Posts |
 Posted - 2005-10-18 : 06:56:38
|
what is DTS? Digital Theatre Sound? ...Defence Travel System? ???the possibilities are endless.please tell me what it means in terms of SQL and how to use it.and what is BCP? Biiiig Computer Programmer?!! |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2005-10-18 : 07:06:18
|
| DTS means.. Data Transformation Services.. this is used for the trasnformation of the data between the 2 different databases or 2 different servers.. etc.. you can look in Book online .. you will get the better picture of itand BCP Means bulk Copy programmes its the utility which run through command promt and its the fast way to add the records in the database.. look in book online.. they are the vast utility usefull for the DBA's...Complicated things can be done by simple thinking |
 |
|
|
iktheone
Yak Posting Veteran
66 Posts |
Posted - 2005-10-18 : 07:12:52
|
| but what is the difference between DTS and BCP and when to use either of the two?Regards, Imran"When there are no comlicated things, u never think!"-Imran |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-10-18 : 07:44:44
|
| DTS can do everthing that bcp can (the Bulk Copy task utilizes the same technology). DTS can also work with non-textual data (Excel, Access, SQL Server, ODBC, etc.) whereas bcp can only work with text and native SQL Server data formats. DTS can also do a lot more with regard to transforming the data, and has an extensive programming model.bcp is a command-line utility; DTSrun is also a command-line utility to run DTS packages. bcp is a simpler utility to use, and once you get the hang of it, it's much easier for importing and exporting data to text files than DTS is.For more information, look in SQL Server Books Online for "bcp" and "DTS". |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-10-18 : 07:55:51
|
| DTS includes wide range of features like import, export to mutiple database which are not evenMS-SQL. You can also create your own task or Active X script to accomplish the task.BCP only deals with bulk copy of data. This can be activate using SQL utility.RegardsSachin Samuel |
|
|
|
iktheone
Yak Posting Veteran
66 Posts |
Posted - 2005-10-18 : 08:15:08
|
| so we do the coding for BCP and DTS both in the Query Analyser right? or is DTS some kind of wizard and only BCP needs to be done in query analyser?RegardsImran |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2005-10-18 : 08:17:31
|
| For DTS there is utility called import export which comes with SQL intallation. .. and where as for BCP you need to create the batch files which is runned using Command prompt..Complicated things can be done by simple thinking |
|
|
|
|
|
|
|
|
what....IS.....DTS....and BCP?....