How to save data in two different databases

[DanielPVilla]

Hello 

I hope you can help me

I wonder if I can save data in two different databases, I need to save the information of my program in two different databases, Is that possible?

If so how?

Regards

Thank you

[PatrickLye]

How to do it will vary with what 2 databases you are using, but build code to save to one database and then build code to the second database. Then run both sets of code to save to two databases.

[Dennis_Knutson]

Off course it is. You can save to how many databases you want to. You save to another database in exactly the same way you do with a single, just with a different UDL file or whatever connection type you are currently using. Simple enough for you to have tried.

[DanielPVilla]

So I have to build another program but with other UDL connection?

Is there another way in that I can join the UDL connections?

[Dennis_Knutson]

No, you can have them both in the same program.

Two different databases require two different connections if you do it all in LabVIEW. You could have one database write to the second, I think. Study the database you are using.

[DanielPVilla]

I can´t join two connection path wires and connect them to the same open data base connection, Because when I try to join two different connection paths the program shows me a broken wire. So I have to create a open database connection for every connection path

[Dennis_Knutson]

Of course you can't use different paths to the same open. Each database requires a different open since, they are, after all different databases. Where did you get the idea that you could use a single open with multiple paths?

[jcarmody]

---

@DanielPVilla wrote:

I can´t join two connection path wires and connect them to the same open data base connection, [...]

---

Make the two paths into an array, wrap your database code in a For loop and wire your path array in.

[Sam_Sharp]

If the databases are identical, depending on the database engine you are using - many support replication and mirroring which means you write to one master database, and the changes get automatically propagated to any number of specified slave databases.

Otherwise, you'll just have to do two operations instead of one for each write to the database. For example, you could have an array of databases and use a for loop to perform the database operations for each one.