Post reply

need help to copy database from SQL server 2000

  • August 31, 2010 at 3:47 pm

    #239792

    I am trying to import data from sql server 2000 to my new database on 2005. First I created new database on 2005 without creating any tables. After that I used Import Wizard (Task->Import data...) and I filled up relative information about source data, destination data etc., It worked and imported all data but I could not import indexes from source database. I can create script from SQL server 2000 and recreate indexes, but is there any way I can import indexes along with data?

  • August 31, 2010 at 3:57 pm

    #1214629

    Why don't you just take a backup of the 2000 database and restore it on SQL 2005? Far easier than scripting and importing

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 31, 2010 at 5:22 pm

    #1214646

    This can cause you grief, as simply copying data will not copy defaults, constraints, keys etc that are defined on the tables.

    As GilaMonster rightly pointed, the easiest way is to backup and restore the database and delete / drop anything that you do not require.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply