select values ​from database to another with sql server2019 Community Moderator Electionincluding parameters in OPENQUERYInsert into … values ( SELECT … FROM … )How do I perform an IF…THEN in an SQL SELECT?Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?How to concatenate text from multiple rows into a single text string in SQL server?When should I use cross apply over inner join?Selecting data from two different servers in SQL ServerHow do I UPDATE from a SELECT in SQL Server?Finding duplicate values in a SQL table

Knife as defense against stray dogs

Do US professors/group leaders only get a salary, but no group budget?

Worshiping one God at a time?

Are dual Irish/British citizens bound by the 90/180 day rule when travelling in the EU after Brexit?

How to terminate ping <dest> &

Do native speakers use "ultima" and "proxima" frequently in spoken English?

Can other pieces capture a threatening piece and prevent a checkmate?

What favor did Moody owe Dumbledore?

Is it true that good novels will automatically sell themselves on Amazon (and so on) and there is no need for one to waste time promoting?

Print last inputted byte

Does .bashrc contain syntax errors?

Usage and meaning of "up" in "...worth at least a thousand pounds up in London"

I seem to dance, I am not a dancer. Who am I?

Is it possible to stack the damage done by the Absorb Elements spell?

Suggestions on how to spend Shaabath (constructively) alone

What should I install to correct "ld: cannot find -lgbm and -linput" so that I can compile a Rust program?

Geography in 3D perspective

Maths symbols and unicode-math input inside siunitx commands

In Aliens, how many people were on LV-426 before the Marines arrived​?

Is it insecure to send a password in a `curl` command?

Asserting that Atheism and Theism are both faith based positions

What is the significance behind "40 days" that often appears in the Bible?

Practical application of matrices and determinants

I got the following comment from a reputed math journal. What does it mean?



select values ​from database to another with sql server



2019 Community Moderator Electionincluding parameters in OPENQUERYInsert into … values ( SELECT … FROM … )How do I perform an IF…THEN in an SQL SELECT?Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?How to concatenate text from multiple rows into a single text string in SQL server?When should I use cross apply over inner join?Selecting data from two different servers in SQL ServerHow do I UPDATE from a SELECT in SQL Server?Finding duplicate values in a SQL table










2















Hello I have to pass a select from a database that is on an ip address to another (identical) database that is on a completely different IP, below the query how to pass to make the switch?



Sql Code:



/*Insert into database with same name into same table addres:: 172.16.50.98*/
Insert into


/* select from database address: 172.16.50.96*/
SELECT IdUtente,Longitudine,Latitudine,Stato,DataCreazione
FROM Quote.dbo.Marcatura
where DataCreazione>'2019-01-08 18:37:28.773'









share|improve this question



















  • 2





    I would do this via SSIS

    – Ajan Balakumaran
    Mar 7 at 10:40











  • is it but how is it done?

    – riki
    Mar 7 at 10:41











  • Or you could use OPENQUERY, OPENROWSET, or linked servers.

    – Larnu
    Mar 7 at 10:41






  • 6





    use SSIS or Linked servers

    – Chanukya
    Mar 7 at 10:41











  • if this is one time activity, you can export to csv from source and import from csv to destination.

    – PSK
    Mar 7 at 10:44















2















Hello I have to pass a select from a database that is on an ip address to another (identical) database that is on a completely different IP, below the query how to pass to make the switch?



Sql Code:



/*Insert into database with same name into same table addres:: 172.16.50.98*/
Insert into


/* select from database address: 172.16.50.96*/
SELECT IdUtente,Longitudine,Latitudine,Stato,DataCreazione
FROM Quote.dbo.Marcatura
where DataCreazione>'2019-01-08 18:37:28.773'









share|improve this question



















  • 2





    I would do this via SSIS

    – Ajan Balakumaran
    Mar 7 at 10:40











  • is it but how is it done?

    – riki
    Mar 7 at 10:41











  • Or you could use OPENQUERY, OPENROWSET, or linked servers.

    – Larnu
    Mar 7 at 10:41






  • 6





    use SSIS or Linked servers

    – Chanukya
    Mar 7 at 10:41











  • if this is one time activity, you can export to csv from source and import from csv to destination.

    – PSK
    Mar 7 at 10:44













2












2








2








Hello I have to pass a select from a database that is on an ip address to another (identical) database that is on a completely different IP, below the query how to pass to make the switch?



Sql Code:



/*Insert into database with same name into same table addres:: 172.16.50.98*/
Insert into


/* select from database address: 172.16.50.96*/
SELECT IdUtente,Longitudine,Latitudine,Stato,DataCreazione
FROM Quote.dbo.Marcatura
where DataCreazione>'2019-01-08 18:37:28.773'









share|improve this question
















Hello I have to pass a select from a database that is on an ip address to another (identical) database that is on a completely different IP, below the query how to pass to make the switch?



Sql Code:



/*Insert into database with same name into same table addres:: 172.16.50.98*/
Insert into


/* select from database address: 172.16.50.96*/
SELECT IdUtente,Longitudine,Latitudine,Stato,DataCreazione
FROM Quote.dbo.Marcatura
where DataCreazione>'2019-01-08 18:37:28.773'






sql sql-server ssis etl






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Mar 8 at 22:52









Hadi

21.7k62974




21.7k62974










asked Mar 7 at 10:37









rikiriki

10912




10912







  • 2





    I would do this via SSIS

    – Ajan Balakumaran
    Mar 7 at 10:40











  • is it but how is it done?

    – riki
    Mar 7 at 10:41











  • Or you could use OPENQUERY, OPENROWSET, or linked servers.

    – Larnu
    Mar 7 at 10:41






  • 6





    use SSIS or Linked servers

    – Chanukya
    Mar 7 at 10:41











  • if this is one time activity, you can export to csv from source and import from csv to destination.

    – PSK
    Mar 7 at 10:44












  • 2





    I would do this via SSIS

    – Ajan Balakumaran
    Mar 7 at 10:40











  • is it but how is it done?

    – riki
    Mar 7 at 10:41











  • Or you could use OPENQUERY, OPENROWSET, or linked servers.

    – Larnu
    Mar 7 at 10:41






  • 6





    use SSIS or Linked servers

    – Chanukya
    Mar 7 at 10:41











  • if this is one time activity, you can export to csv from source and import from csv to destination.

    – PSK
    Mar 7 at 10:44







2




2





I would do this via SSIS

– Ajan Balakumaran
Mar 7 at 10:40





I would do this via SSIS

– Ajan Balakumaran
Mar 7 at 10:40













is it but how is it done?

– riki
Mar 7 at 10:41





is it but how is it done?

– riki
Mar 7 at 10:41













Or you could use OPENQUERY, OPENROWSET, or linked servers.

– Larnu
Mar 7 at 10:41





Or you could use OPENQUERY, OPENROWSET, or linked servers.

– Larnu
Mar 7 at 10:41




6




6





use SSIS or Linked servers

– Chanukya
Mar 7 at 10:41





use SSIS or Linked servers

– Chanukya
Mar 7 at 10:41













if this is one time activity, you can export to csv from source and import from csv to destination.

– PSK
Mar 7 at 10:44





if this is one time activity, you can export to csv from source and import from csv to destination.

– PSK
Mar 7 at 10:44












3 Answers
3






active

oldest

votes


















0














Linked Server/ OpenQuery is the way to achieve this. have a look on this.



including parameters in OPENQUERY






share|improve this answer






























    0














    If the data that's being imported isn't large and this won't be a reoccurring task a linked server would probably be the better option. Creating one through the SSMS GUI is easier if you haven't done this before, but an example of creating one using the SP_ADDLINKEDSERVER stored procedure through T-SQL is below. If your account doesn't have access to the other server the SP_ADDLINKEDSRVLOGIN stored procedure will need to be used to configure the linked server with an account that has the appropriate permissions on the source server, as well as database and any referenced objects. While using the linked server syntax (4 part name) is simpler and easier to read, I'd strongly recommend doing the insert with OPENQUERY instead if only one linked server will be used. This will execute the SQL on the source server, applying any filters there and only return the necessary rows, whereas the linked server syntax will return all the rows before performing the filtering. You can read more about the differences between the two here. You indicated the database name is the same on both servers, and this assumes the same for the table and schema names as well. Make sure to update these accordingly if they differ.



    If a large volume of the data will imported or if this will be a regular process creating an SSIS package and setting this to run as a SQL Agent job will be the better approach. If you choose to go this route there are a number of things to consider, but the links below will help you get started. SQL Server Data Tools (SSDT) is where the packages can be developed. While not necessary, executing the packages from the SSIS Catalog, SSISDB, will be much more beneficial than just the using the file system. Either an OLE DB or SQL Server Destination can be used since the table that's being loaded to is on SQL Server, however a SQL Server Destination can only be used on a local database.



    Linked Server:



     --Create linked server
    --SQL product name and SQLNCLI11 provider for SQL Server
    EXEC [MASTER].DBO.SP_ADDLINKEDSERVER @server = N'MyLinkedServer', @srvproduct=N'SQL',
    @provider=N'SQLNCLI11', @datasrc=N'ServerIPAddress'


    --OPENQUERY insert
    INSERT INTO Quote.dbo.Marcatura (IdUtente, Longitudine, Latitudine, Stato, DataCreazione)
    SELECT
    IdUtente,
    Longitudine,
    Latitudine,
    Stato,
    DataCreazione
    FROM OPENQUERY(MyLinkedServer, '
    SELECT
    IdUtente,
    Longitudine,
    Latitudine,
    Stato,
    DataCreazione
    FROM Quote.dbo.Marcatura')


    SSIS:



    • SSIS

    • SSDT

    • SSISDB

    • Execute SQL Task

    • Data Flow Task

    • OLE DB Source

    • OLE DB Destination

    • SQL Server Destination

    • SQL Server Agent SSIS Packages





    share|improve this answer






























      0














      SSIS solution



      I think this requires a very simple SSIS package to be achieved:



      1. Create two OLEDB Connection manager; one for each server

      2. Add a data flow task

      3. Inside the Data flow task addan OLEDB Source and OLEDB destination


      4. In the OLEDB source (172.16.50.98 connection manager) select SQL command as Access mode and use the following command:



        SELECT IdUtente,Longitudine,Latitudine,Stato,DataCreazione
        FROM Quote.dbo.Marcatura
        where DataCreazione >'2019-01-08 18:37:28.773'


      5. Map the source columns to the OLEDB destination (172.16.50.96 connection manager)


      Helpful links



      • Extract Data by Using the OLE DB Source

      • SSIS OLEDB Source to OLE DB Destination example





      share|improve this answer






















        Your Answer






        StackExchange.ifUsing("editor", function ()
        StackExchange.using("externalEditor", function ()
        StackExchange.using("snippets", function ()
        StackExchange.snippets.init();
        );
        );
        , "code-snippets");

        StackExchange.ready(function()
        var channelOptions =
        tags: "".split(" "),
        id: "1"
        ;
        initTagRenderer("".split(" "), "".split(" "), channelOptions);

        StackExchange.using("externalEditor", function()
        // Have to fire editor after snippets, if snippets enabled
        if (StackExchange.settings.snippets.snippetsEnabled)
        StackExchange.using("snippets", function()
        createEditor();
        );

        else
        createEditor();

        );

        function createEditor()
        StackExchange.prepareEditor(
        heartbeatType: 'answer',
        autoActivateHeartbeat: false,
        convertImagesToLinks: true,
        noModals: true,
        showLowRepImageUploadWarning: true,
        reputationToPostImages: 10,
        bindNavPrevention: true,
        postfix: "",
        imageUploader:
        brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
        contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
        allowUrls: true
        ,
        onDemand: true,
        discardSelector: ".discard-answer"
        ,immediatelyShowMarkdownHelp:true
        );



        );













        draft saved

        draft discarded


















        StackExchange.ready(
        function ()
        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55041727%2fselect-values-from-database-to-another-with-sql-server%23new-answer', 'question_page');

        );

        Post as a guest















        Required, but never shown

























        3 Answers
        3






        active

        oldest

        votes








        3 Answers
        3






        active

        oldest

        votes









        active

        oldest

        votes






        active

        oldest

        votes









        0














        Linked Server/ OpenQuery is the way to achieve this. have a look on this.



        including parameters in OPENQUERY






        share|improve this answer



























          0














          Linked Server/ OpenQuery is the way to achieve this. have a look on this.



          including parameters in OPENQUERY






          share|improve this answer

























            0












            0








            0







            Linked Server/ OpenQuery is the way to achieve this. have a look on this.



            including parameters in OPENQUERY






            share|improve this answer













            Linked Server/ OpenQuery is the way to achieve this. have a look on this.



            including parameters in OPENQUERY







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Mar 7 at 11:54









            KG18KG18

            183




            183























                0














                If the data that's being imported isn't large and this won't be a reoccurring task a linked server would probably be the better option. Creating one through the SSMS GUI is easier if you haven't done this before, but an example of creating one using the SP_ADDLINKEDSERVER stored procedure through T-SQL is below. If your account doesn't have access to the other server the SP_ADDLINKEDSRVLOGIN stored procedure will need to be used to configure the linked server with an account that has the appropriate permissions on the source server, as well as database and any referenced objects. While using the linked server syntax (4 part name) is simpler and easier to read, I'd strongly recommend doing the insert with OPENQUERY instead if only one linked server will be used. This will execute the SQL on the source server, applying any filters there and only return the necessary rows, whereas the linked server syntax will return all the rows before performing the filtering. You can read more about the differences between the two here. You indicated the database name is the same on both servers, and this assumes the same for the table and schema names as well. Make sure to update these accordingly if they differ.



                If a large volume of the data will imported or if this will be a regular process creating an SSIS package and setting this to run as a SQL Agent job will be the better approach. If you choose to go this route there are a number of things to consider, but the links below will help you get started. SQL Server Data Tools (SSDT) is where the packages can be developed. While not necessary, executing the packages from the SSIS Catalog, SSISDB, will be much more beneficial than just the using the file system. Either an OLE DB or SQL Server Destination can be used since the table that's being loaded to is on SQL Server, however a SQL Server Destination can only be used on a local database.



                Linked Server:



                 --Create linked server
                --SQL product name and SQLNCLI11 provider for SQL Server
                EXEC [MASTER].DBO.SP_ADDLINKEDSERVER @server = N'MyLinkedServer', @srvproduct=N'SQL',
                @provider=N'SQLNCLI11', @datasrc=N'ServerIPAddress'


                --OPENQUERY insert
                INSERT INTO Quote.dbo.Marcatura (IdUtente, Longitudine, Latitudine, Stato, DataCreazione)
                SELECT
                IdUtente,
                Longitudine,
                Latitudine,
                Stato,
                DataCreazione
                FROM OPENQUERY(MyLinkedServer, '
                SELECT
                IdUtente,
                Longitudine,
                Latitudine,
                Stato,
                DataCreazione
                FROM Quote.dbo.Marcatura')


                SSIS:



                • SSIS

                • SSDT

                • SSISDB

                • Execute SQL Task

                • Data Flow Task

                • OLE DB Source

                • OLE DB Destination

                • SQL Server Destination

                • SQL Server Agent SSIS Packages





                share|improve this answer



























                  0














                  If the data that's being imported isn't large and this won't be a reoccurring task a linked server would probably be the better option. Creating one through the SSMS GUI is easier if you haven't done this before, but an example of creating one using the SP_ADDLINKEDSERVER stored procedure through T-SQL is below. If your account doesn't have access to the other server the SP_ADDLINKEDSRVLOGIN stored procedure will need to be used to configure the linked server with an account that has the appropriate permissions on the source server, as well as database and any referenced objects. While using the linked server syntax (4 part name) is simpler and easier to read, I'd strongly recommend doing the insert with OPENQUERY instead if only one linked server will be used. This will execute the SQL on the source server, applying any filters there and only return the necessary rows, whereas the linked server syntax will return all the rows before performing the filtering. You can read more about the differences between the two here. You indicated the database name is the same on both servers, and this assumes the same for the table and schema names as well. Make sure to update these accordingly if they differ.



                  If a large volume of the data will imported or if this will be a regular process creating an SSIS package and setting this to run as a SQL Agent job will be the better approach. If you choose to go this route there are a number of things to consider, but the links below will help you get started. SQL Server Data Tools (SSDT) is where the packages can be developed. While not necessary, executing the packages from the SSIS Catalog, SSISDB, will be much more beneficial than just the using the file system. Either an OLE DB or SQL Server Destination can be used since the table that's being loaded to is on SQL Server, however a SQL Server Destination can only be used on a local database.



                  Linked Server:



                   --Create linked server
                  --SQL product name and SQLNCLI11 provider for SQL Server
                  EXEC [MASTER].DBO.SP_ADDLINKEDSERVER @server = N'MyLinkedServer', @srvproduct=N'SQL',
                  @provider=N'SQLNCLI11', @datasrc=N'ServerIPAddress'


                  --OPENQUERY insert
                  INSERT INTO Quote.dbo.Marcatura (IdUtente, Longitudine, Latitudine, Stato, DataCreazione)
                  SELECT
                  IdUtente,
                  Longitudine,
                  Latitudine,
                  Stato,
                  DataCreazione
                  FROM OPENQUERY(MyLinkedServer, '
                  SELECT
                  IdUtente,
                  Longitudine,
                  Latitudine,
                  Stato,
                  DataCreazione
                  FROM Quote.dbo.Marcatura')


                  SSIS:



                  • SSIS

                  • SSDT

                  • SSISDB

                  • Execute SQL Task

                  • Data Flow Task

                  • OLE DB Source

                  • OLE DB Destination

                  • SQL Server Destination

                  • SQL Server Agent SSIS Packages





                  share|improve this answer

























                    0












                    0








                    0







                    If the data that's being imported isn't large and this won't be a reoccurring task a linked server would probably be the better option. Creating one through the SSMS GUI is easier if you haven't done this before, but an example of creating one using the SP_ADDLINKEDSERVER stored procedure through T-SQL is below. If your account doesn't have access to the other server the SP_ADDLINKEDSRVLOGIN stored procedure will need to be used to configure the linked server with an account that has the appropriate permissions on the source server, as well as database and any referenced objects. While using the linked server syntax (4 part name) is simpler and easier to read, I'd strongly recommend doing the insert with OPENQUERY instead if only one linked server will be used. This will execute the SQL on the source server, applying any filters there and only return the necessary rows, whereas the linked server syntax will return all the rows before performing the filtering. You can read more about the differences between the two here. You indicated the database name is the same on both servers, and this assumes the same for the table and schema names as well. Make sure to update these accordingly if they differ.



                    If a large volume of the data will imported or if this will be a regular process creating an SSIS package and setting this to run as a SQL Agent job will be the better approach. If you choose to go this route there are a number of things to consider, but the links below will help you get started. SQL Server Data Tools (SSDT) is where the packages can be developed. While not necessary, executing the packages from the SSIS Catalog, SSISDB, will be much more beneficial than just the using the file system. Either an OLE DB or SQL Server Destination can be used since the table that's being loaded to is on SQL Server, however a SQL Server Destination can only be used on a local database.



                    Linked Server:



                     --Create linked server
                    --SQL product name and SQLNCLI11 provider for SQL Server
                    EXEC [MASTER].DBO.SP_ADDLINKEDSERVER @server = N'MyLinkedServer', @srvproduct=N'SQL',
                    @provider=N'SQLNCLI11', @datasrc=N'ServerIPAddress'


                    --OPENQUERY insert
                    INSERT INTO Quote.dbo.Marcatura (IdUtente, Longitudine, Latitudine, Stato, DataCreazione)
                    SELECT
                    IdUtente,
                    Longitudine,
                    Latitudine,
                    Stato,
                    DataCreazione
                    FROM OPENQUERY(MyLinkedServer, '
                    SELECT
                    IdUtente,
                    Longitudine,
                    Latitudine,
                    Stato,
                    DataCreazione
                    FROM Quote.dbo.Marcatura')


                    SSIS:



                    • SSIS

                    • SSDT

                    • SSISDB

                    • Execute SQL Task

                    • Data Flow Task

                    • OLE DB Source

                    • OLE DB Destination

                    • SQL Server Destination

                    • SQL Server Agent SSIS Packages





                    share|improve this answer













                    If the data that's being imported isn't large and this won't be a reoccurring task a linked server would probably be the better option. Creating one through the SSMS GUI is easier if you haven't done this before, but an example of creating one using the SP_ADDLINKEDSERVER stored procedure through T-SQL is below. If your account doesn't have access to the other server the SP_ADDLINKEDSRVLOGIN stored procedure will need to be used to configure the linked server with an account that has the appropriate permissions on the source server, as well as database and any referenced objects. While using the linked server syntax (4 part name) is simpler and easier to read, I'd strongly recommend doing the insert with OPENQUERY instead if only one linked server will be used. This will execute the SQL on the source server, applying any filters there and only return the necessary rows, whereas the linked server syntax will return all the rows before performing the filtering. You can read more about the differences between the two here. You indicated the database name is the same on both servers, and this assumes the same for the table and schema names as well. Make sure to update these accordingly if they differ.



                    If a large volume of the data will imported or if this will be a regular process creating an SSIS package and setting this to run as a SQL Agent job will be the better approach. If you choose to go this route there are a number of things to consider, but the links below will help you get started. SQL Server Data Tools (SSDT) is where the packages can be developed. While not necessary, executing the packages from the SSIS Catalog, SSISDB, will be much more beneficial than just the using the file system. Either an OLE DB or SQL Server Destination can be used since the table that's being loaded to is on SQL Server, however a SQL Server Destination can only be used on a local database.



                    Linked Server:



                     --Create linked server
                    --SQL product name and SQLNCLI11 provider for SQL Server
                    EXEC [MASTER].DBO.SP_ADDLINKEDSERVER @server = N'MyLinkedServer', @srvproduct=N'SQL',
                    @provider=N'SQLNCLI11', @datasrc=N'ServerIPAddress'


                    --OPENQUERY insert
                    INSERT INTO Quote.dbo.Marcatura (IdUtente, Longitudine, Latitudine, Stato, DataCreazione)
                    SELECT
                    IdUtente,
                    Longitudine,
                    Latitudine,
                    Stato,
                    DataCreazione
                    FROM OPENQUERY(MyLinkedServer, '
                    SELECT
                    IdUtente,
                    Longitudine,
                    Latitudine,
                    Stato,
                    DataCreazione
                    FROM Quote.dbo.Marcatura')


                    SSIS:



                    • SSIS

                    • SSDT

                    • SSISDB

                    • Execute SQL Task

                    • Data Flow Task

                    • OLE DB Source

                    • OLE DB Destination

                    • SQL Server Destination

                    • SQL Server Agent SSIS Packages






                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Mar 7 at 17:15









                    userfl89userfl89

                    3,0091513




                    3,0091513





















                        0














                        SSIS solution



                        I think this requires a very simple SSIS package to be achieved:



                        1. Create two OLEDB Connection manager; one for each server

                        2. Add a data flow task

                        3. Inside the Data flow task addan OLEDB Source and OLEDB destination


                        4. In the OLEDB source (172.16.50.98 connection manager) select SQL command as Access mode and use the following command:



                          SELECT IdUtente,Longitudine,Latitudine,Stato,DataCreazione
                          FROM Quote.dbo.Marcatura
                          where DataCreazione >'2019-01-08 18:37:28.773'


                        5. Map the source columns to the OLEDB destination (172.16.50.96 connection manager)


                        Helpful links



                        • Extract Data by Using the OLE DB Source

                        • SSIS OLEDB Source to OLE DB Destination example





                        share|improve this answer



























                          0














                          SSIS solution



                          I think this requires a very simple SSIS package to be achieved:



                          1. Create two OLEDB Connection manager; one for each server

                          2. Add a data flow task

                          3. Inside the Data flow task addan OLEDB Source and OLEDB destination


                          4. In the OLEDB source (172.16.50.98 connection manager) select SQL command as Access mode and use the following command:



                            SELECT IdUtente,Longitudine,Latitudine,Stato,DataCreazione
                            FROM Quote.dbo.Marcatura
                            where DataCreazione >'2019-01-08 18:37:28.773'


                          5. Map the source columns to the OLEDB destination (172.16.50.96 connection manager)


                          Helpful links



                          • Extract Data by Using the OLE DB Source

                          • SSIS OLEDB Source to OLE DB Destination example





                          share|improve this answer

























                            0












                            0








                            0







                            SSIS solution



                            I think this requires a very simple SSIS package to be achieved:



                            1. Create two OLEDB Connection manager; one for each server

                            2. Add a data flow task

                            3. Inside the Data flow task addan OLEDB Source and OLEDB destination


                            4. In the OLEDB source (172.16.50.98 connection manager) select SQL command as Access mode and use the following command:



                              SELECT IdUtente,Longitudine,Latitudine,Stato,DataCreazione
                              FROM Quote.dbo.Marcatura
                              where DataCreazione >'2019-01-08 18:37:28.773'


                            5. Map the source columns to the OLEDB destination (172.16.50.96 connection manager)


                            Helpful links



                            • Extract Data by Using the OLE DB Source

                            • SSIS OLEDB Source to OLE DB Destination example





                            share|improve this answer













                            SSIS solution



                            I think this requires a very simple SSIS package to be achieved:



                            1. Create two OLEDB Connection manager; one for each server

                            2. Add a data flow task

                            3. Inside the Data flow task addan OLEDB Source and OLEDB destination


                            4. In the OLEDB source (172.16.50.98 connection manager) select SQL command as Access mode and use the following command:



                              SELECT IdUtente,Longitudine,Latitudine,Stato,DataCreazione
                              FROM Quote.dbo.Marcatura
                              where DataCreazione >'2019-01-08 18:37:28.773'


                            5. Map the source columns to the OLEDB destination (172.16.50.96 connection manager)


                            Helpful links



                            • Extract Data by Using the OLE DB Source

                            • SSIS OLEDB Source to OLE DB Destination example






                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered Mar 8 at 22:52









                            HadiHadi

                            21.7k62974




                            21.7k62974



























                                draft saved

                                draft discarded
















































                                Thanks for contributing an answer to Stack Overflow!


                                • Please be sure to answer the question. Provide details and share your research!

                                But avoid


                                • Asking for help, clarification, or responding to other answers.

                                • Making statements based on opinion; back them up with references or personal experience.

                                To learn more, see our tips on writing great answers.




                                draft saved


                                draft discarded














                                StackExchange.ready(
                                function ()
                                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55041727%2fselect-values-from-database-to-another-with-sql-server%23new-answer', 'question_page');

                                );

                                Post as a guest















                                Required, but never shown





















































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown

































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown







                                Popular posts from this blog

                                Identity Server 4 is not redirecting to Angular app after login2019 Community Moderator ElectionIdentity Server 4 and dockerIdentityserver implicit flow unauthorized_clientIdentityServer Hybrid Flow - Access Token is null after user successful loginIdentity Server to MVC client : Page Redirect After loginLogin with Steam OpenId(oidc-client-js)Identity Server 4+.NET Core 2.0 + IdentityIdentityServer4 post-login redirect not working in Edge browserCall to IdentityServer4 generates System.NullReferenceException: Object reference not set to an instance of an objectIdentityServer4 without HTTPS not workingHow to get Authorization code from identity server without login form

                                2005 Ahvaz unrest Contents Background Causes Casualties Aftermath See also References Navigation menue"At Least 10 Are Killed by Bombs in Iran""Iran"Archived"Arab-Iranians in Iran to make April 15 'Day of Fury'"State of Mind, State of Order: Reactions to Ethnic Unrest in the Islamic Republic of Iran.10.1111/j.1754-9469.2008.00028.x"Iran hangs Arab separatists"Iran Overview from ArchivedConstitution of the Islamic Republic of Iran"Tehran puzzled by forged 'riots' letter""Iran and its minorities: Down in the second class""Iran: Handling Of Ahvaz Unrest Could End With Televised Confessions""Bombings Rock Iran Ahead of Election""Five die in Iran ethnic clashes""Iran: Need for restraint as anniversary of unrest in Khuzestan approaches"Archived"Iranian Sunni protesters killed in clashes with security forces"Archived

                                Can't initialize raids on a new ASUS Prime B360M-A motherboard2019 Community Moderator ElectionSimilar to RAID config yet more like mirroring solution?Can't get motherboard serial numberWhy does the BIOS entry point start with a WBINVD instruction?UEFI performance Asus Maximus V Extreme