Post reply

Very basic data import question

  • April 19, 2005 at 7:43 am

    #163367

    Hi,

    When I do data import using Enterprise manager and choose the option "Copy table(s) and View(s) from source database", Am I telling Sql Server to convert the views from the source database to tables in the destination database ?

    Thanks

    Dinuj

    Thanks and Regards,

    Dinuj Nath

  • April 19, 2005 at 8:00 am

    #553445

    No.  Using this option transfers the object(s) between server(s) or database(s).  SQL does NOT convert from 1 object type to the other.



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • April 20, 2005 at 1:21 am

    #553662

    Yes Dinuj, Using this option "Copy table(s) and View(s) from source database", the views in the source database get created as tables in the destination database.

    Regards

    Meghana

    Regards,

    Meghana

  • April 20, 2005 at 1:24 am

    #553663

    Thanks AJ,

    But this is exactly what happened. The view returns about 8000000 records and while importing with the options described in my post the view got converted to table.

    I don't know what's happening. I am not a DBA and I have limited knowledge of admin.

    Thanks and Regards,

    Dinuj Nath

  • April 20, 2005 at 1:32 am

    #553664

    Dinuj

    If you want the view in the source to be created as a view in destination db , use the option

    "copy objects and data between SQL servers" instead of the option

    "Copy table(s) and View(s) from source database"

    this will solve your problem.

     

    Regards

    Meghana

     

     

     

    Regards,

    Meghana

  • April 20, 2005 at 4:42 am

    #553718

    Thank you all

    Thanks and Regards,

    Dinuj Nath

  • April 21, 2005 at 7:14 am

    #554064

    This is the reason I start my day with sqlservercentral.com even before my ritualistic cup of tea...

    I haven't had occasion to use import (for views)...so this is definitely a noteworthy point to keep in mind if I ever do need to use it...







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 7 posts - 1 through 7 (of 7 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