HELP!!! How to Query multiple database server

[jenueheightz]

Hello fellow istoryans,

kinsa kahibaw unsaon pag handle query to multiple mssql db servers? naka linked na ang mga servers ang kuwang nalang is pag implement sa sql na dynamic iyang servername

SELECT * FROM [servername].dbname.dbo.tablename

dapat mn dynamic ang servername sa sql...

need your experties guys..


thanks

[moz_k2]

kailangan ba nga 1 db ra cya connected at a time?
asa ka mag query gikan? app, dbtools, etc.

[raybanz21]

Maybe you can use grants from tables para 1 server db lang imo i access but you can call some other serverdb... ana among gamit sa oracle..

[junkfactory]

@jenueheightz - .NET imo gamit brad? Kung mao man gani, try lookup sa reflection mechanism sa framework.

[jenueheightz]

kailangan ba nga 1 db ra cya connected at a time?
asa ka mag query gikan? app, dbtools, etc.

nag query ko gikan sa app... dili 1 db at a time. depende sa akong parameter na akong ipasa from app then base sa parameter, mahibaw-an naman na asa nga dbserver siya kuha ug data.

[jenueheightz]

any idea how to implement this into stored procedure or user defined function?

[raybanz21]

any idea how to implement this into stored procedure or user defined function?

MS SQL gihapon noh? hmm...

[dodie]

oooopppsss. hahaha

[bluedes]

I've been to MySQLalready.
As the rules in database protocol...... ONLY 1 SERVER for 1 MYSQL SERVER. You can see in the documentation. Querying mysql servers is an awkward tasks but possible.

You have to involve mysql nodes and all those techno jargonz on the mysql server settings to let allow alien/remote access to allow it. If that is available on your servers. hehehehe.

Try to see if there is SERVER QUERY within those queries? Until now, I didn't even see one in the documentations. hahahaha.

mssql ang gipangutana brad, dili mysql...

[dodie]

Anywayz..... lisud gihapon tingale brad. Dapat naa jud protocol or PORT ana.
I think pwede multiple tables or multiple databases.

Multiple servers, ----> Since ang server agi gihapon ug PORT or something.... Mao ra gihapon ang concept brad. hehehehe