mssql-cli icon indicating copy to clipboard operation
mssql-cli copied to clipboard

Published 20 hours ago • verified publisher icon dbcli

Database Dumps

Open pastoolio opened this issue 6 years ago • 6 comments

Hi there.

Is there some way this tool can be used to make and restore database dumps?

pastoolio avatar Feb 27 '18 14:02 pastoolio

I would really like a solution to make backups of remote MS SQL databases using a remote Linux connection.

pastoolio avatar Feb 28 '18 08:02 pastoolio

All the backup/restore operation occur on server side, this client like SSMS/SQLCMD just send the command to the SQL Server create/restore the backup.

bigleka avatar May 11 '18 14:05 bigleka

check out this project: https://github.com/Microsoft/mssql-scripter We really just need to integrate that tool into mssql-cli.

twright-msft avatar Nov 18 '18 08:11 twright-msft

Integrating mssql-scripter into mssql-cli is part of our roadmap for mssql-cli.

yualan avatar Nov 19 '18 18:11 yualan

Is there any news on mssql-scripter integration into mssql-cli?

jdottori avatar Sep 02 '19 13:09 jdottori

Hello, I am on linux I want to dump a public microsfot express server database, how is that possible? I just tried dbeaver GUI client but it keep complaining during export that I do not have INSERT permissions on some table, making me abort the process.

kopax avatar Sep 16 '20 12:09 kopax