1

I have a MS-SQL database and want to generate the script of this database with all the create table, create sequence and insert commands (as a "backup-Script").

I can do this in my MS SQL Server Management Studio manually, but is there a commandline command for this? For MySQL Databases I found this:

$ mysqldump -u [uname] -p[pass] db_name > db_backup.sql

in addition to my primary question: how do I rewrite the "login" part (u [uname] -p[pass]), when I want to use my Windows-Authentification?

Dmitrij Kultasev
  • 5,447
  • 5
  • 44
  • 88
Dave
  • 37
  • 3
  • Your MySQL Server is an Enterprise Edition? – sticky bit May 25 '18 at 10:47
  • I've ask because it looks like only the Enterprise Edition supports integrated Windows authentication. See https://dev.mysql.com/doc/refman/5.5/en/windows-pluggable-authentication.html I didn't find if especially `mysqldump` supports it and how. But in any case the Enterprise Edition seems to be required. – sticky bit May 25 '18 at 11:29
  • 1
    Possible duplicate of [mysqldump equivalent for SQL Server](https://stackoverflow.com/questions/85186/mysqldump-equivalent-for-sql-server) – SMor May 25 '18 at 14:08

0 Answers0