Info
| Version: | 2.6.1 |
| Author(s): | datconn |
| Last Update: | Monday, January 24, 2022 |
| .NET Fiddle: | Create the first Fiddle |
| Project Url: | https://github.com/fjiang2/sqlcon/ |
| NuGet Url: | https://www.nuget.org/packages/sqlcon |
Install
Install-Package sqlcon
dotnet add package sqlcon
paket add sqlcon
sqlcon Download (Unzip the "nupkg" after downloading)
Dependencies
- Tie(>= 2.0.7)
sqlcon command: dir,cd,md,rd,del,type,ren,copy,comp,xcopy,cls,ver,echo,rem,set,import,export,mount,umount,open,save,edit,clean,execute,attrib
Support SQL Server, LocalDB, SQL Azure, SQL Server Express
Support Xml database on disk or web/ftp site which is used to compare database on 2 differnet networks.
Support unlimited database server connections
Compare data/schema between 2+ databases or database servers, and generate SQL script
Copy data/schema between 2+ databases or database servers
Search data rows, column, table, view, proc and database name by wildcard(*,?)
Edit data on GUI or console
Clean redundant rows
Delete rows with constraints
Generate data in format of json, CSV, and SQL script
Generate C# class: data contract, Linq to SQL, and entity framework
Execute SQL Script file
Support all SQL statements.