erhangundogan/sql2mongodb

MS SQL Server to MongoDB export tool

sql2mongodb (aka priceless)

MS SQL Server - MongoDB export tool

MS SQL Server initialization and MongoDB export tool. It uses node.js and express for web server architecture; websocket(socket.io) and traditional http protocols, MSSQL connectivity with Tedious and MongoDb connectivity with Mongoose. MongoDB session management using as well. You can connect to MS SQL Server and query databases. When you are fine with the table or stored procedure, export it's structure and data to MongoDB server if you want. You can use nginx 1.3.13(latest) for WebSocket experience.

Project is under development.

How to Install

npm install -d sql2mongodb

How to use

node app.js

Ajax usage

http://localhost:3000/old

WebSocket usage

http://localhost:3000

Troubleshooting

• If you enter user and password correct you would see databases on combobox otherwise you may not able to connect to mssql server.
• When you have selected database from combobox then you should write table in memo
• stored procedures and query functionality is not implemented yet
• mssql named instances not supported cause of tedious
• Records begin id is line number, not a guid or something else
• You may have timer display bug
• You may experience slow transfer on windows platform after some period if you have a lot of records on mssql ( > 1 million )

Author

Erhan Gundogan

• http://twitter.com/erhangundogan
• http://github.com/erhangundogan

License

Copyright 2013 Erhan Gundogan

Licensed under the MIT License.

sql2mongodb's Issues

Can not work.

$ node app.js
C:\Users\b\Desktop\sql2mongodb-master\node_modules_socket.io@[email protected]\lib\store.js:35
Store.prototype.proto = EventEmitter.prototype;
^

TypeError: Cannot read property 'prototype' of undefined
at Object. (C:\Users\b\Desktop\sql2mongodb-master\node_modules_socket.io@[email protected]\lib\store.js:35:42)
at Module._compile (module.js:662:30)
at Object.Module._extensions..js (module.js:673:10)
at Module.load (module.js:575:32)
at tryModuleLoad (module.js:515:12)
at Function.Module._load (module.js:507:3)
at Module.require (module.js:606:17)
at require (internal/module.js:11:18)
at Object. (C:\Users\b\Desktop\sql2mongodb-master\node_modules_socket.io@[email protected]\lib\manager.js:16:13)
at Module._compile (module.js:662:30)

Hata

Merhaba,

Express
500 Error: E:\nodejs\node_modules\sql2mongodb/views/index_ajax.jade:12 10| function on_done(result) { 11| $("#result-panel").html(result); > 12| } 13| 14| function on_append(result) { 15| $("#append-panel").html(result); unexpected text }

şeklinde hata alıyorum çalıştırdığım zaman!