Hi

I want to develop data archival process.basically i have one doubt.i want to store the data in json format.first of all is it possible to store huge json data in SQL server or i can choose binary format.its basically for audit purpose.if i mention text and size if i mention more than 2000 then it will act as nvarchar max.but my doubt is which one is the good option for historical data archive process?please find historical archiving process in the below link

https://success.outsystems.com/Documentation/Best_Practices/Data_Archiving.

Please suggest me which one is the good option.

Hi,

I would say NVARCHAR(max) is the best option since it is even the type that SQL server 2016 uses to represent JSON. Read about it here.

Regards,

Marcelo

Marcelo Ferreira wrote: ok.thanks.i am thinking also the same thing.binary is not a good option,in future we will face performance issue.

Hi,

I would say NVARCHAR(max) is the best option since it is even the type that SQL server 2016 uses to represent JSON. Read about it here.

Regards,

Marcelo