Results 1 to 2 of 2

Thread: How to insert data from local to remote

  1. Apr 15th, 2010, 12:55 PM #1
    aspfun
    aspfun is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2010
    Posts
    478

    How to insert data from local to remote

    How to insert data from local SQL server to remote SQL server (without using linked server) like below?

    insert * into [remote server].[northwind].orders
    from [local server].[northwind].orders
    Reply With Quote Reply With Quote
  2. Apr 15th, 2010, 04:00 PM #2
    plender
    plender is offline
    Lively Member
    Join Date
    Apr 2010
    Posts
    105

    Re: How to insert data from local to remote

    You can't without writing an application to do it for you, i.e.;
    Pull records from Server A
    Send records to Server B
    I wrote a book Visual Studio 2008 Programming
    Amazon.com / Visual Studio 2008 Programming / By Jamie Plenderleith & Steve Bunn
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width