CHANGEDB

ChangeDB is a multi-database cli convert tool, it's all about making database migration much more easier.

📕 How to use

1. Install Dotnet (net5/net6). ChangeDB is supported by dotnet sdk, please check the link Here to setup your personal dotnet sdk.
2. Install ChangeDB tool. you can follow the command below to setup tool quite easily.

   dotnet tool install ChangeDB.ConsoleApp -g

3. Database converting. you can use changedb migration command convert database. Like the example command below, you need to provide source database type, source database connection string, target database type and target database connection string to establish migrate task. and for target database, changedb tool has the ability to create a new target database even if not exists. so you don't create a empty database everytime first.

   changedb migration {source-database-type} "{source-connection-string}" {target-database-type} "{target-connection-string}" 

4. Dump database to sql scripts, changedb tool also has the ability to generate sql scripts. you can use changedb dumpsql command，Like the example example below to create sql scripts.

   changedb dumpsql {source-database-type} "{source-connection-string}" {target-database-type} "{output-file}" 

5. Here we use Northwind.sql as source data to show how we migrate between different type of database

📦 Supported Database

• Sql Server
• Postgres
• Mysql
• Sql Server Compact (only supported in windows)

🏗️Architecture diagram

🔗Database Formate Connection String

Database	Format connection string	Extend usages
Sql Serve	Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;	Link
Postgres	Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;Password=myPassword;	Link
Mysql	Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;	Link
Sql Server Compact	Data Source=MyData.sdf;Persist Security Info=False;	Link

🧩Database Object Supported

Category	Object	Sql Server	Postgres	Mysql	Sql Server Compact
Table	identity	✔️	✔️	✔️	✔️
Table	index	✔️	✔️	✔️	✔️
Table	unique	✔️	✔️	✔️	✔️
Table	default constant value	✔️	✔️	✔️	✔️
Table	default function value	✔️(newid,getdate)	✔️(gen_random_uuid,now)	✔️(uuid,now)	✔️(newid,getdate)
Table	foreign key	✔️	✔️	✔️	✔️
Table	unique index	✔️	✔️	✔️	✔️