.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

A New Tool that moves SQL data to NoSQL quickly

Posted By:Brian Langbecker       Posted Date: November 06, 2013    Points: 25    Category: DataBase    URL: http://www.dotnetspark.com  

A tutorial to show using a free tool to quickly move SQL to a Windows .NET NoSQL database.
 

In this article, we are going to walk you through doing using FatDB Management Studio to move data from SQL to a Windows .NET NoSQL DB. 

We start by creating a table in SQL Server using the script below:

CREATE TABLE [dbo].[ProdDesc] (
    [Id]       INT            NOT NULL,
    [Model]    NVARCHAR (50)  NOT NULL,
    [Make]     NVARCHAR (MAX) NOT NULL,
    [Category] NVARCHAR (50)  NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_ProdDesc_Category]
    ON [dbo].[ProdDesc]([Category] ASC);


Next, we start the FatDB Management Studio, and select "New Data Store".   While it can be added at a later time, please add the SQL connection string to the SQL Server database with the table we created above. Next, press "Create". 

You can update the connection string by selecting the "Properties" of the data store, as well.

     

Next, select "New Definition" and create the fields below.  And then press "Create".

So now we have our SQL table and our FatDB NoSQL data store, seen below.  We are almost done.

Next, select "Import from SQL Table" and press "Start".  It will begin importing records in batches and notify you when it's complete.


Lastly, let's actually look at our data.  Press "Inspect Data" and a screen like below will show.  You can also add data from here, update items, and delete them.

So, what have we shown you?  We have shown you how to take data from SQL Server and import that data into NoSQL (FatDB) with no custom code.  

If you are new to FatDB and want to learn more about FatDB, go here.  Some instructional webinars/videos can be found at Integration with SQL Server and Write-back and Write-through with SQL.

 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend