dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: Duplicating tables/defaults/settings within same database

  1. #1
    Join Date
    Dec 2002
    Location
    St. Louis, MO, USA
    Posts
    1,582

    Duplicating tables/defaults/settings within same database

    Hello, all.

    I have an MS-SQL database (I think it's SQL Server 2000 or 2003) that I would like to create duplicate tables with slightly different names, copy all the defaults/indeces/triggers and other settings, AND copy all the data, too.

    Is there a way to do this without using a DTS?

    Thanks,

    ^_^

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    hmmm. only thing i could think of off the top of my head would be to take an export/backup and manually changing the names.

Thread Information

Users Browsing this Thread

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

Posting Permissions

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



Recent Articles