5

I am using windows7 os and i have a database on MSSQL server 2005 i am using following codes to import database

sqlcmd -S [server instance name] -d [database name] -i [filename you want to import]

i want to export database something like above command if any?

1
  • By "export database" do you mean "backup database" ?
    – krisFR
    Mar 27, 2014 at 13:03

2 Answers 2

3

Assuming you've the right permissions, try:

SqlCmd -E -S Server_Name –Q "BACKUP DATABASE [Name_of_Database] TO DISK=’X:PathToBackupLocation[Name_of_Database].bak'"

Note: Instead of -E, you can use -U and -P to specify user credentials.

Then to restore, use the following syntax:

SqlCmd -E -S Server_Name –Q "RESTORE DATABASE [Name_of_Database] FROM DISK=’X:PathToBackupFile[File_Name].bak'"

Source: Backup and Restore Your SQL Server Database from the Command Line.

To export specific data, see: How to export data as CSV format from SQL Server using sqlcmd?

2

The -i is to import a procedure/table/whatever from a file and there is a -o option to output a table/procedure to a file. See sqlcmd.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.