Re: Connecting to two servers

It is possible with SQL and a simple TAdoQuery:

INSERT INTO myDatabase1.dbo.myTable1
SELECT * FROM myDatabase2.dbo.myTable1

Joachim


F Alvarado wrote:

I need to access two tables in two different servers (MS SQL Server
2005) and append data from one table to the second one.
.

Relevant Pages

  • Re: Truncated Blob Field in TADOQuery
    ... I used a TADOStoredProc instead and the problem went away. ... suspect that ti has to do with the manner in which TADOQuery handles ... and pumping it down into a MS SQL db locally. ... > of the parameter in the TADOQuery component before calling the ExecSQL ...
    (borland.public.delphi.database.ado)
  • Re: MSAccess and ADO
    ... database I use TADOQuery and SQL ... Stanko. ...
    (borland.public.delphi.database.ado)
  • Re: Which is faster??
    ... SQL inserts will always run faster that opening an entire table and posting. ... If you are using MS Access, TADOQuery should be faster, but not by much. ... using TADOTable components and essentially the code looks like this... ... change to INSERT and UPDATE SQL queries be faster?? ...
    (borland.public.delphi.database.ado)
  • Re: the dbgrid will be uneditable
    ... only sqlserver tables and the program running in delphi can generate that ... >>if using tadoquery and sql to join two tables,the dbgrid will be ...
    (borland.public.delphi.database.ado)
  • Identity_Insert wont turn off
    ... I'm attempting to append data from an Access table to an SQL 2005 linked ... table in Access that has an identity field. ... When I run this query in SQL SMSE it works fine, then I run my append query ...
    (microsoft.public.access.externaldata)