Using a DTS in SQL Server 2000

[TomBarrand]

I have used a DTS in SQL Server 2000 to transfer my database from one server to another. In the first instance of the database I had typed in descriptions for the columns in each of the tables. When I did the DTS the descriptions were not there. The database is quite big so I do not want to have to re-type this.

Any suggestions?

Thanks,

Tom

 

[tlbroadbent]

If you set up the transfer using the DTS Import/Export Wizard, make sure you choose the third option the specify table copy or query dialog. The 3rd option is 'Copy objects and data between SQL Server databases.'

On the next dialog screen, make sure you check on 'Include extended properties.' That should do it. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.