Migrating from MS SQL Database

Technical Discussion
#1

I have a MS SQL database that I would like to migrate the data into a nem project. Would I be able to pull the data from the tables and queries or would I need to export to csv?

The goal is to move +10,000 of rows of data to the nem then manage the files and be able to export the data when needed.

Is that possible?

Thank you,

#2

I’m not sure what you want to do.
Blockchain is not designed to store large amount of data.

#3

I have a student management system. So, I have two thoughts.

  1. store the students transcripts/permeant record on a “private” block chain. To save paper and space.
  2. the district I work at has a lot of students transferring in and out all year. Moving at least the transfer students to the block chain would speed up the process of sending or receiving the required documents.

Thanks,

#4

NEM is neither a file storage nor storing any bigger amount of foreign data in the chain.
I don’t think what you want is possible in a sensible way.

#5

I’m not taking about files, just the data.
If the block chain doesn’t store the data, then what does it store? What happens when the block chain size is 1 TB?
From what I know is that it stores every transaction from day one, is that all it stores? In nem, where are the assets stored?

Please correct me if I’m wrong.

Thanks for your time,

#6

A blockchain stores indeed transactions. Each transaction changes the state of the system, e.g. adds an account / changes the balance of some asset. But the NEM blockchain was not designed to store custom data. There is a message field for each transfer transaction but it can only store ~1kb and it was thought as having the possibility to add some message to the transfer like an invoice number.

#7

Thank you for the info.
That would work then. It would be one line per year/transaction per asset, which would be less than 1k per block.