Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Vancouver
    Posts
    1

    Question Unanswered: Loss of Column properties when exporting with DTS

    Exporting a sql 2000 database from one sql 2000 server to another. I am using DTS import/export Wizard. The data transfers fine but column properties such as identity = yes or default value = (getdate()) are lost in transfer. What am I missing??

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    May check this DB JOurnal article.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •