Python to create json file containing specific records from SQL Server database
Budget: $250 – $750 USD
Hello,
I have an SQL 2008 database and need some records extracted to a json file. I'll have to run this each day against multiple databases so I'd like a python script to do this. Here are specific notes:
Json schema is attached. Will need to export into this model.
json should connect to our SQL Server/instance..database to pull the specific records based on a specific SQL Where condition.
I have a more detailed schema with notes tied directly to our SQL database.
I have SQL scripts used to create each element/node of the json.
Should discuss methods to run this manually. Would also be interested in further development for some automation or processing records from a specific log file in a different database.
Please DM me for a sample database and more detailed json schema.
I have an SQL 2008 database and need some records extracted to a json file. I'll have to run this each day against multiple databases so I'd like a python script to do this. Here are specific notes:
Json schema is attached. Will need to export into this model.
json should connect to our SQL Server/instance..database to pull the specific records based on a specific SQL Where condition.
I have a more detailed schema with notes tied directly to our SQL database.
I have SQL scripts used to create each element/node of the json.
Should discuss methods to run this manually. Would also be interested in further development for some automation or processing records from a specific log file in a different database.
Please DM me for a sample database and more detailed json schema.