none
Ssis copy data from view to view RRS feed

  • Question

  • Hi,

    i want to copy the view data from one server to another server how can i achive this?

    server1 - view1 i need to copy data from this view to server2-view1 using ssis  pkg.

    Monday, September 17, 2012 8:59 AM

Answers

  • Views do not hold data. You can visualize them as a window to the data in your database. So what you realy need is to copy the views from the source to destination database. If its a one time activity you can choose to generate the script from your source db and execute those scripts on the destination database. If its a more periodic thing then use Transfer SQL Server Object Tasks as suggested by ETL vs ETl. Check this on how to use this component in SSIS. From the link in the second snapshot set "CopyAllViews" to true to copy over the views.


    http://btsbee.wordpress.com/

    • Marked as answer by Eileen Zhao Monday, September 24, 2012 7:19 AM
    Monday, September 17, 2012 12:27 PM

All replies

  • Ravinderp... 

    A view is defined by a query and only shows the data which is defined at the time of creation of the view. so I think you just need to copy the definition of view from Server1 to server2. 

    here you can use "Transfer SQL Server Objects Task" in SSIS to transfer your SQL objects.. 

    --


    Let us TRY this |


    My Blog :: http://quest4gen.blogspot.com/

    Monday, September 17, 2012 9:48 AM
  • Views do not hold data. You can visualize them as a window to the data in your database. So what you realy need is to copy the views from the source to destination database. If its a one time activity you can choose to generate the script from your source db and execute those scripts on the destination database. If its a more periodic thing then use Transfer SQL Server Object Tasks as suggested by ETL vs ETl. Check this on how to use this component in SSIS. From the link in the second snapshot set "CopyAllViews" to true to copy over the views.


    http://btsbee.wordpress.com/

    • Marked as answer by Eileen Zhao Monday, September 24, 2012 7:19 AM
    Monday, September 17, 2012 12:27 PM