Post reply

How to move specific columns from one DB to another one?

  • August 14, 2011 at 6:18 am

    #255508

    Hello All!

    We have following situation: 2 SQL Servers. In one server we have Database, let's say called "User_Profiles", that holds 10 columns. I need to create some job, that copies data "User_Profiles", but, only from 2 Columns, to the DB, that reside in another SQL Server.

    How can i do it?

    Thanks a lot!

  • August 14, 2011 at 7:04 am

    #1368378

    Simple update or merge statement.

    Checkout linked servers in books online. Pretty easy to set up.

    SSIS is another option but it's a bit bigger learning curve.

  • August 14, 2011 at 7:44 am

    #1368383

    Hello All!

    My bad - didn't understand what i need to do.

    I have some correlation:

    1. In "User_Profiles" DB i have some View.

    2. I need to copy all Data from View in "1" to DB in another SQL Server.

    Thanks!

  • August 14, 2011 at 10:41 am

    #1368395

    There's an import wizard which works cross server.

    right click on the db, tasks, import (or export) data. Then follow the wizard. You can save that package in case you need to rerun.

  • August 15, 2011 at 2:33 am

    #1368474

    But i can't use this Wizard, because it can't use View, only whole DB.

  • August 15, 2011 at 7:11 am

    #1368582

    pavlenych (8/15/2011)

    But i can't use this Wizard, because it can't use View, only whole DB.

    I'd check permissions on your views, cuz the import/export wizard should allow you to move data from a view.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • August 16, 2011 at 11:05 am

    #1369208

    You will probably have to use a SQL Query statement that SELECTS the fields you want from the source view.

Viewing 7 posts - 1 through 6 (of 6 total)

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