Write to SQL

Hi Joao ,

One approach I have seen is to use the Report Server to host the code to write values to the SQL database. This handles the Primary/Standby complexity, so only one will run at a time. If the Primary is shutdown, the Standby will start executing the cicode. There are a number of TechNotes that describe this (TN25540).

Also for SQL code examples, have a look at the Cicode functions SQLOpen, SQLConnect. The Example project also has some code and pages that illustrate how to use them.

Hi Joao ,

One approach I have seen is to use the Report Server to host the code to write values to the SQL database. This handles the Primary/Standby complexity, so only one will run at a time. If the Primary is shutdown, the Standby will start executing the cicode. There are a number of TechNotes that describe this (TN25540).

Also for SQL code examples, have a look at the Cicode functions SQLOpen, SQLConnect. The Example project also has some code and pages that illustrate how to use them.

Thank you Olivier. 

"Also for SQL code examples, have a look at the Cicode functions SQLOpen, SQLConnect. The Example project also has some code and pages that illustrate how to use them."

My problem isn't to write to the sql, is how can i managed with redudante servers.

Best Regards