Replace Database Table Records

Ignition
1

Hello. I have two databases.
There’s one Table which is intended to have an identical copy in both databases. DatabaseA contains the ‘master’ version of the Table.
At the click of a button in an Ignition Client; I wish to delete the contents of the DatabaseB Table, then update it with all the records from the DatabaseA Table.
Can this be achieved in a single step with one method (such as “Replace”)?
Or do I need to pull the data from DatabaseA Table into a PowerTable, then delete the DatabaseB Table data, then insert the PowerTable data into the DatabaseB Table?

2

What database is it ?

You can set up a synchronize tables outside of ignition with the database it self.

3

Hi craigb. The database is SQL server 2012. I’m also fairly new to databases.