How to copy data between two orion databases using API script?

blue0o0

Hi all,

I have tried to alter my existing orion datase collation, just follow this article:

https://support.solarwinds.com/SuccessCenter/s/article/Supported-SolarWinds-Orion-database-collations-for-Orion-Platform-2015-1-or-later 

I used second method in this article, when i execute the command, it's interrupted by some error. See detail in this post:

https://thwack.solarwinds.com/thread/130427

Someone suggested me using first method in the article, that is:

1. Create a backup of current database
2. Re-install SQL instance with a supported collation
3. Re-create tables
4. Import data from old databse's tables

And I found someone else encounter the same issue, he finally ended up with setting up a new system and copied over the Data by an API Script.

Alter SQL Collation of Solarwinds Database

So I want to konw how to copy data between two orion databases by API script. Anyone could help me or give me some reference documentation?