Skip to main content
Question

Data (X Format) to Azure SQL


Forum|alt.badge.img

Hello,

 

I have an XML file (consists of 300+ entities) that I wish to insert to Azure SQL, thus creating 300+ tables.

 

When inserting data to Azure (contrary to SQL Server) you must specify a primary key or a clustered index. I know this type of functionality is feasible by changing the attributes of the Writer at the Index column.

 

However, doing this for 300+ tables manually, is not sustainable.

 

Dynamic writer was not able to assist either. My other thought is to read as merged dataset, create a uuid and then using SQL Executor assign this attribute as a clustered index in every table? In this case, will the Writer be able to pick up this automatically?

 

Other suggestions are much appreciated.

 

Kind regards,

 

George

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings