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
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)
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,
Some instructional webinars/videos can be found at Integration with SQL Server
and Write-back and
Write-through with SQL.