Kurt W. Zimmerman (1/22/2015)
I agree with you simply spinning though a cursor is easy to write. What I've done was develop a control table that contains the name of the table and the status. This way I can run multiple copies of the same script without table contention.I did this with the syncing process I wrote and had as many as 8-10 processes running at the same time. I had to watch the disk IOs, memory usage & NIC utilization because it was easy to swamp those resources and bring everything to a halt.
Great! Then you already have the perfect setup for automating this.
I attempted to use your DB_BulkCopy last evening with no success. Maybe if I can drop you a PM with the errors I was receiving to sort this out.
Yes, that would be great.
Take care,
Solomon..
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR