SQL Select from one sql server into another without linked servers in vb.net

  Dim SQLConnection As New SqlConnection()
        Dim ConnString2 As String = "Data Source=data;Initial Catalog=cat; User Id=sa; Password=blabla;"
        SQLConnection.ConnectionString = ConnString2

        Try
            SqlConnection.Open()

        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try


        Dim expr As String = "SELECT City, State, Zip, home_phone as Phone FROM dbo.people"

        Dim objCmdSelect As SqlCommand = New SqlCommand(expr, SQLConnection)

        
        Dim objDR As SqlDataReader

        Dim SQLconn As New SqlConnection()
        Dim ConnString As String = ""Data Source=data2;Initial Catalog=cat2; User Id=sa; Password=blabla;"
        SQLconn.ConnectionString = ConnString
        SQLconn.Open()




        Using bulkCopy As SqlBulkCopy = New SqlBulkCopy(SQLconn)
            bulkCopy.DestinationTableN<wbr ></wbr><wbr ></wbr>ame = "Import"

            Try
                objDR = objCmdSelect.ExecuteReader<wbr ></wbr><wbr ></wbr>
                bulkCopy.WriteToServer(obj<wbr ></wbr><wbr ></wbr>DR)
                objDR.Close()
                SQLconn.Close()



                MsgBox("Import Completed Successfully!!")

Select allOpen in new window