Post reply

How to load tables(with data) and dependent objects from DB to the other ?

  • December 18, 2012 at 2:39 am

    #286398

    hello All ,

    Can someone suggest me how I Can load tables and its dependent objects from one DB to the other DB dropping tables in old ones after successfully verifying both the Db's are in same server . I think i can use import/export wizard is there any best way i can do it..I do not want to use any software to use other then that comes with Sql Server Ent version..

    Thanks in Advance...

  • December 18, 2012 at 4:07 am

    #1569463

    just script it out and select the option with data and all required dependency you want.

    Its advisable to generate the script per object.

    Also, better have two different script folder

    1) object creation

    2) data load

    then you can script the things and put them in required folder

    ----------
    Ashish

  • December 18, 2012 at 5:44 am

    #1569503

    Hi ashish thanks for the reply...

    can i have the steps please coz i dont see the option for with dataload and I am a newbee here..

    Thanks

  • December 18, 2012 at 5:44 am

    #1569504

    by the way we use sql 2k5

  • December 18, 2012 at 5:48 am

    #1569507

    not sure it "script with data"option is in sql 2005 or not but you can just copy the backup and restore on any 2008 server. Script it out and the same script will be applicable for 2005 as well (if you still prefer on 2005) 😀

    ----------
    Ashish

Viewing 5 posts - 1 through 4 (of 4 total)

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