search

microsoft / mssql-scripter

Repository for the new SQL cross-platform command line tools
Other
742 stars 148 forks source link

Restore .sql file to DB #283

Closed rangosheriff closed 9 months ago

rangosheriff commented 9 months ago

Is there any utility that reads the .sql file generated by mssql-scripter? The schema only /data only/schema-and-data .sql file generated contains GO as batch separators . Is there any utility that automatically reads and executes the statements thereby restoring the table in another DB?

ErikEJ commented 9 months ago

sqlcmd

felipegouveiae commented 9 months ago

I usually restore the backup with SQLCMD with the -i option