With what command, in sql server, you can transfer the database from one server to another server?

    2 answers 2

    Commands backup / restore

      need to export database dump

      We unload the SQL database to the file:

      mysqldump имябазыданных -u > user_name_db -ppassword_db -h IP (или > localhost) > db_name.sql

      Load SQL database from file:

       > mysql имябазыданных -u user_name_db > -ppassword_db < db_name.sql
      • it is not clear how to do this - gurgen
      • And what server? And there are a lot of them, good and different ... - alexlz
      • It is considered (in my environment) that this is MS SQL Server - renegator
      • for MS SQL there are a lot of utilities - Alex Kapustin
      • I have MS SQL 2008 R2. - gurgen