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 |
|
7crystal7
Starting Member
7 Posts |
 Posted - 2003-04-03 : 02:36:08
|
| Hi guys,I want to move 2 table from a sql server 6.5 database to a sql server 2000 database.. What's the best way to do this?BCP, bulk insert?Thank YouBabsi |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-03 : 12:37:49
|
| Well, in my opinion, the best way is to use bcp, but some people prefer bulk insert. Still other people prefer DTS. But I would suggest bcp.Tara |
 |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-04-04 : 00:36:09
|
quote:
Well, in my opinion, the best way is to use bcp, but some people prefer bulk insert. Still other people prefer DTS. But I would suggest bcp.
Tara,Is there any Specific advantages of BCP rather using BULK INSERT or DTS  Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-04-04 : 07:25:01
|
| bcp is available for pretty much every version of SQL Server; DTS and BULK INSERT were introduced with 7.0. However, you can use DTS to access a SQL 6.5 server.bcp and BULK INSERT also have less overhead than DTS, and if you have very simple import and export operations they are usually faster than DTS. But if it's a one time import and you need something easy, use the Import/Export wizard in DTS. |
|
|
|
|
|
|
Moving Tables from SQL Server 6.5 to 2000