HELP!!! How to Query multiple database server

[jenueheightz]

---

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

pwede mn jud na maka query multiple server bai basta naka set na ang linked server sa mssql enterprise manager. naka query naman ko karon duha ka server at the same time. problem lang jud nko is hardcoded pa ang sql nko (select * from [servername].dbname.dbo.table) ang servername nko is hardcoded pa. kailangan jud daw ni ug stored procedure para dynamic ang pag query.

[xiao-xiao]

research about DDS... Distributed Database Systems.

[bishop__]

pwede mn jud na maka query multiple server bai basta naka set na ang linked server sa mssql enterprise manager. naka query naman ko karon duha ka server at the same time. problem lang jud nko is hardcoded pa ang sql nko (select * from [servername].dbname.dbo.table) ang servername nko is hardcoded pa. kailangan jud daw ni ug stored procedure para dynamic ang pag query.

Kun sa app ka manukad, himo-ang variable string ang imong SQL query bai para mausab2x nimo ang servername, pero kun gusto ka dito sa StoredProc ka manukad, dili man pwede tingali kay ang scope sa storedproc within your db server ra man.

[xiao-xiao]

ang stored proc murag something...
if table exist ana nga server then execute ang [servername].dbname.dbo.table

[kolz]

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

Btw, how did you setup your linked servers? Did you do it via Enterprise Manager?

Fyi, there's already a system stored proc called sp_addlinkedserver, link below
sp_addlinkedserver

You can call the stored procedure to link additional server to provide additional data sources. After that, you can then proceed with your select statement with 4 part naming i.e. [servername].dbname.dbo.tablename or you can also use OPENQUERY.

This article might answer your problem:
How to perform a SQL Server distributed query with OLAP Server

[xiao-xiao]

^
I guess that will answer your problem

[sanggano_boy]

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

okie, try lang nako.


if kung sa application rani nimo gigamit. imong gi try something like this?

var_servername="db1"

txtsql="SELECT * FROM ["+ var_servername +"].dbname.dbo.tablename..."

adodb.execute txtsql

[Rainerius]

Why not just something like:

Select Case Param
Case ParamA
//Create your database connection, command objects and execute it against your DB for A
Case ParamB
//Create your database connection, command objects and execute it against your DB for B
End Select