connect 2 databases

[#1]

i have 2 databases to connect to,is it possisble to do so?

if yes then

My script doesnt have a proper pattern such as, first all the data from server1 will be picked and then server2 will be connected for data.

It needs to connect to server1 for first table, then server2 for 2nd table and then again server1 for another table and so on...

So what is the best way to make this happen and keep the load performance optimized.

let me know if any more details are required from my end.

Regards,

Amrit

[#2]

Hey Amrit,

I guess you mean that you have two differente database servers. If so you could use two different connection strings for the two different servers.

For example for the first server:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=SERVER1 ;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=RDS;Use Encryption for Data=False;Tag with column collation when possible=False];

For the second server:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=SERVER2 ;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=RDS;Use Encryption for Data=False;Tag with column collation when possible=False];

However, it might be faster to first get all the data from the first server and store the data as QVD file. And then load all the data from server 2 and store it as QVD data. After all the data is loaded you can filter the data you need.

Hope this helps.

Gr.

Frank

[#3]

In my current deployment i use different QVW's to load the data from different databases and then store them in qvd files. Something like

- QVD_Generator_Oracle

- QVD_Generator_MySql

- QVD_Generator_RandomDatabase

I found this way of working very comfortable since i only work with QVD's and Excel files on the QVW's that the users can open.