Post reply

How to move indexes from one database to another database??

  • July 26, 2012 at 5:30 am

    #392838

    Hi All,

    I created a new database in test server.i moved all tables data from production to UAT by using import/export wizard.The task was completed successfully but the indexes was not created in new database .

    So i want to move all the indexes prod database to test database .

    any one please let me know how can i achieve this ..........

    Thanks

    Lavanya

  • July 26, 2012 at 5:43 am

    #1517847

    you can script the indexes on one server(db) and run the script inside the other.

  • July 26, 2012 at 7:36 am

    #1517936

    Lavanyasri (7/26/2012)

    Hi All,

    I created a new database in test server.i moved all tables data from production to UAT by using import/export wizard.

    Thanks

    Lavanya

    is there any reason why you have used import/export instead of DB scripting or DB restore.

    Regards
    Durai Nagarajan

  • July 26, 2012 at 8:42 am

    #1517984

    Thanks Hadrian .

    Could you please provide the script plz

  • July 26, 2012 at 8:57 am

    #1518001

    we don't have enough disk space to take the backup in prod. Every day backup is taking by using third aprty tool . So by using this backup file its not possible to restore in Test server .

    So i preferred this option

  • July 26, 2012 at 9:08 am

    #1518009

    Lavanyasri (7/26/2012)

    we don't have enough disk space to take the backup in prod. Every day backup is taking by using third aprty tool . So by using this backup file its not possible to restore in Test server .

    So i preferred this option

    In that case, I would prefer to generate complete DB script (DDLs only).

    Then, run CREATE TABLE first, export data, run rest of the DDL script(PK,FK,Other objects like SPs,fns,Trgs,....)

    --

    well still you can generate DB script and then execute everything else without CREATE TABLE script

    To generate script: right click DB in SSMS -> Tasks-> Generate Scripts...

  • July 26, 2012 at 9:26 am

    #1518020

    I tried the below scenario but its not creating indexes.

    generate script: right click DB in SSMS -> Tasks-> Generate Scripts...

  • July 26, 2012 at 9:35 am

    #1518027

    Lavanyasri (7/26/2012)

    I tried the below scenario but its not creating indexes.

    generate script: right click DB in SSMS -> Tasks-> Generate Scripts...

    Did you make sure "Script Indexes" = true, in script wizard?

  • July 27, 2012 at 3:21 am

    #1518356

    Thanks ,

    I already created tables in test environment ?Now can i created only indexes in that database ??

  • July 30, 2012 at 1:40 am

    #1519015

    yes create the table script with "Include if not exists" as yes then table wont be created but index will be created.

    Regards
    Durai Nagarajan

Viewing 10 posts - 1 through 10 (of 10 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy