Board index » delphi » Exporting Tables using Data Transformation Services

Kevin

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Exporting Tables using Data Transformation Services

Dear all

I tried to export tables from one SQL Server 7 database to another SQL
Server 7 database using the DTS. All tables are copied to the 2nd database
except tables primary keys and indexes. Is there any option I need to set
for copying the indexes as well?

Thanks

Kevin

 
Euan Garde

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Exporting Tables using Data Transformation Services


DTS only supports the copy of basic DDL and data. It does not support
constraints.
The capability to do this was pulled from the RTM version of SQL2000.

-Euan

Quote
"Kevin" <kevin_k...@hotmail.com> wrote in message news:39a2c953_2@dnews...
> Dear all

> I tried to export tables from one SQL Server 7 database to another SQL
> Server 7 database using the DTS. All tables are copied to the 2nd database
> except tables primary keys and indexes. Is there any option I need to set
> for copying the indexes as well?

> Thanks

> Kevin

Other Threads

1. Data Transformation Services (DTS) versus ADO query

2. DTS (MS Data Transformation Services) in Delphi?

3. Data Transformation Services in Delphi

4. Need to import/export data from text table

5. Exporting ADO data to local table

6. SaveToFile/LoadFromFile used to Import/Export data

7. Exporting data from Access table to Excel-how to use ADO

8. Using SQL Export data to excel

9. Using Delphi To Export SQL Query Data TO Excel

10. How to Export Data from Oracle Tables