netcorestack / datatransform

Sql2Sql or Sql2MongoDb Transform Tool

SQL to SQL or SQL to MongoDb Transform Tool

NetCoreStack DataTransform is a tool for application developers, data analysts and database administrators to transform and collect various data type from different SQL providers to SQL or MongoDb database.

Watch the video

Build and Test

Install .NET Core 2.0 SDK for your development environment.

Clone the repo on your local machine.

Use Docker to get SQL Server and MongoDb running instances.

MongoDb Database (v3.6+)

docker volume create --name=mongodata

docker run -it -v mongodata:/data/db -p 27017:27017 -d mongo

SQL Server 2017 Linux Database

docker build -t localsql .

docker run -p 1401:1433 --name sql1 -d localsql

once above commands are completed you can run afterdockerbuild file to retore the sample MusicStore database for running SQL Server 2017 instance.