Results 1 to 4 of 4

Thread: DTS Wizard on SQL Server 2005

  1. 6th June 2007, 10:20 AM #1
    creativeworks's Avatar
    RFH Reseller: creativeworks
    creativeworks is offline Red Fox Hosting Reseller
    Join Date
    Jun 2005
    Location
    Tunbridge Wells, Kent
    Posts
    206
    Thanks
    6
    Thanked 2 Times in 2 Posts

    Default DTS Wizard on SQL Server 2005

    When copying database tables from one SQL database to another blank SQl database, the tables lose their 'identity columns' and become just a normal column and the columns also drop their status as 'primiary key'.

    Why is this, is there a way to copy a DB from one to another and the tables keep this information?
    Reply With Quote Reply With Quote
  2. 6th June 2007, 07:58 PM #2
    RFH Reseller: askjim
    askjim is offline Red Fox Hosting Reseller
    Join Date
    Jan 2006
    Posts
    419
    Thanks
    2
    Thanked 16 Times in 16 Posts

    Default

    Could you script the database and run this before executing a dts package?
    Reply With Quote Reply With Quote
  3. 11th June 2007, 05:34 PM #3
    Sol's Avatar
    RFH Reseller: Sol
    Sol is offline Red Fox Hosting Reseller
    Join Date
    Jun 2005
    Posts
    1,081
    Thanks
    4
    Thanked 15 Times in 15 Posts

    Default

    You could have a look at the Database Publishing Wizard.
    Reply With Quote Reply With Quote
  4. 15th June 2007, 08:46 AM #4
    Mark Voss's Avatar
    RFH Reseller: Mark Voss
    Mark Voss is offline Red Fox Hosting Reseller
    Join Date
    Jan 2005
    Location
    Cardiff
    Posts
    449
    Thanks
    10
    Thanked 17 Times in 17 Posts

    Default

    Looks just the job.

    Thanks Sol.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Connecting to SQL Server 2005 with SQL Server Management Studio Express
    By jack in forum MSSQL
    Replies: 9
    Last Post: 20th February 2007, 08:17 PM
  2. Connect to Red fox hosted SQL Server 2005 database using SQL Server Management Studio
    By fevster in forum Development Support
    Replies: 2
    Last Post: 2nd August 2006, 03:04 PM
  3. SQL Server 2005 - What do you want?
    By Warren Ashcroft in forum Technical Support
    Replies: 17
    Last Post: 20th May 2006, 08:19 PM
  4. SQL Server 2005
    By DavidJenkins in forum Sales and Service Feature Enquiries
    Replies: 17
    Last Post: 15th May 2006, 08:36 AM

Bookmarks

Posting Permissions

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

Forum Rules