If others, why would you want to flatten objects into 2D tables ?
I can understand saving data to SQL and having a ps script query the data and do something with it.But then its data, not PS objects. Remember that a DB table isnt always the best sotrage for all operations, sometimes a text file / ini file would be easier.
Thank you for the quick reply.
I need to store custom objects that will contain basically some string and datetime properties.
In fact you helped me by referring to XML or JSON.
Is it possible to store json in SQL server 2012 db?
Furthermore it is mandatory to use SQL server (referring to the alternative way of storing data).
You can store any info you want in SQL, the structre is not "important". You can store pictures for that matter
that said, SQL2012 supports XML as a native datatype, so you can have a table with a column that is an XML document. As it's natively supported it means you can even do a select statement to find a specif value down the tree on the SQL itself, without needing to send the XML to the client and let it parse it.
In SQL 2016 JSON will be supported "almost" natively