Reputation: 1610
I am porting an old SSIS package to AWS Glue. The package runs daily. In several steps in this package, I take data from one table on one Microsoft SQL Server and copy all of it to an empty table of identical schema on another Microsoft SQL Server. I wish to replicate these steps in AWS Glue. This would be rather easy if I could write code in C# or PowerShell's dbatools because, like SSIS, they all use SqlBulkCopy
either directly or indirectly. Unfortunately, I am under the following restrictions:
SqlBulkCopy
or an equivalent.With these restrictions in mind, what options do I have? Do either Python or AWS Glue provide an alternative to .NET's SqlBulkCopy
?
Upvotes: 3
Views: 202