Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Backing Up A Database To Use In Another Database.

forums › forums › SQLyog › Query Builder and Schema Designer › Backing Up A Database To Use In Another Database.

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 29, 2011 at 8:03 pm #12466
      xarzu
      Member

      I want to make a copy of a sql server database into a sql txt asci file so that i can port the data into another database to be used perhaps with your software.

      Does anyone know how to use Microsoft SQL Server Management Studio to create a database backup file?

    • September 29, 2011 at 10:27 pm #32692
      peterlaursen
      Participant

      If you want to migrate a SQL server database to MySQL check the 'import external data' tool. from SQLyog 'powertools' menu.

      I dont know how to export a SQL Server dtabase to a text file, but even if you manage to do so you should not expect that it will import to MySQL. SQL 'dialects' are too much different.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.