I have a database in my SQL Server which has multiple tables and the size of the database is around 25 GB.
I want to index this data to Elasticsearch 5.6 (As it supports mapping of multiple types). However the column names in some of the tables have invalid name such as a [.] in between words, etc.
I'd like to convert all the tables into a single json file and then fix the field names and then index the data to elasticsearch. I'm having a hard time figuring out how to do this. I've read some links such as this and this but I need to fix the column names before indexing.
How do I convert the SQL tables (multiple) into json and then after fixing the names, index it to elasticsearch? Are there any other ways to fix this?