Python imports the SQL Server database into the MongoDB database

Import pymssql
From Pymongo import mongoclient
conn = Pymssql.connect (' IP ', ' username ', ' password ', ' database ')
cursor = conn.cursor (as_dict = True)
Cursor.execute ("Select Top V_alerts. Source,v_alerts. Filepath,v_alerts. Alertdatetime,v_alerts. Alertenddatetime,alertmsg. ALERT, Sem_computer.computer_name,sem_computer.current_login_user from (V_alerts left join alertmsg on V_alerts. Alert_idx= alertmsg. ALERT_IDX) LEFT join sem_computer on v_alerts.computer_idx = sem_computer.computer_id ")
Client = mongoclient (' localhost ', 27017)
db = client. SEPM
Collection = DB.SEPM
For row in cursor:
Print (ROW)
Collection.insert_one (Row)
For item in Collection.find ():
Print (item)

Python imports the SQL Server database into the MongoDB database