...@gmail.com]
Sent: Friday, January 16, 2009 8:25 AM
To: cf-talk
Subject: Re: join two databases
> You need to link your SQL Server instances. Google "SQL Server
Linked".
>
> You can link the servers both directions, if needed.
>
> With the server linked in SQL, yo
ver or the
server that is referenced in your datasource.
mike
-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com]
Sent: Friday, January 16, 2009 8:23 AM
To: cf-talk
Subject: RE: join two databases
Ah.. so there is a way in MS SQL to link two servers together.
Then I would just add
Message-
From: C. Hatton Humphrey [mailto:chumph...@gmail.com]
Sent: Friday, January 16, 2009 9:25 AM
To: cf-talk
Subject: Re: join two databases
> You need to link your SQL Server instances. Google "SQL Server
> Linked".
>
> You can link the servers both directions, i
mentioned that "SQL Server Linked" stuff. That's interesting. I'll have
to see if that's possible with oracle.
brad
-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com]
Sent: Friday, January 16, 2009 9:18 AM
To: cf-talk
Subject: RE: join two database
> You need to link your SQL Server instances. Google "SQL Server Linked".
>
> You can link the servers both directions, if needed.
>
> With the server linked in SQL, you can create cross-server queries in
> the Query Analyzer/New Query editor.
Well would ya look at that! Learn something new ever
.
Chad
> -Original Message-
> From: Dawson, Michael [mailto:m...@evansville.edu]
> Sent: Friday, January 16, 2009 9:13 AM
> To: cf-talk
> Subject: RE: join two databases
>
> You need to link your SQL Server instances. Google "SQL Server Linked".
>
can you preface the database name with the dns name in CF Admin?
Dsn1.database1.dbo.table1?
> -Original Message-
> From: Duane Boudreau [mailto:du...@sandybaynetworks.com]
> Sent: Friday, January 16, 2009 9:09 AM
> To: cf-talk
> Subject: RE: join two databases
>
&
You need to link your SQL Server instances. Google "SQL Server Linked".
You can link the servers both directions, if needed.
With the server linked in SQL, you can create cross-server queries in
the Query Analyzer/New Query editor.
mike
-Original Message-
From: Chad Gray [mailto:cg...@
> What is the best way to join tables across two databases servers?
>
> Say I have one MS SQL server that has a database that stores ERP product
> data. I have our website MS SQL server that stores extra data about the
> product records in the ERP database.
>
> Is it possible to hook each dataso
You can reference the database by name in the query
Ex:
select t1.Field1, t2.Field2, t2.Field3
fromdatabase1.dbo.Table1 t1
inner join database2.dbo.Table2 t2 on t1.Field = t2.Field
you might need to put that into a stored procedure or use a dsnless
connection
-
10 matches
Mail list logo