I have some data in multiple tables (ACTTAB, APTTAB, ...)
How do I export this data from SQL and insert into a text file?
How can I import this data into MongoDB?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
There is a tool on CodePlex you can use for this, called MSSQL to MongoDB Tool. This tool will migrate all data from MSSQL to MongoDB. It will do this without exporting to a file first.
If you want to export to file first, you are best off using the Export Data wizard which you can find in your SSMS, by right clicking your DB and choose 'Export Data' under 'Tasks'
The answer to your question is that you need to remodel your data for MongoDB to suit your use cases and write some ETL routine for migrating the data into a proper model which makes use of MongoDBs advantages.
Generally, using these tools is a bad idea. Since a tool has no idea what your use cases (and subsequently your questions to MongoDB) are, it can't even give you a raw structure which is halfway optimal. If your current models are optimal, why change the database technology? And if they aren't, why would you try to translate them "word by word"? For the features? My opinion on that
So tools which translate your current structure will always give you only the best approximation of your SQL datas translation to NoSQL. Very Bad Idea™. In my experience when using transformation tools you get over normalized data, which at best don't make use of the advantages MongoDB has to offer and at worst will be a real performance killer since there are no joins. Instead of processing one command on the database server, joins would have to be simulated in subsequent (and possibly not non-consistent) multiple queries.