Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Query Builder and Schema Designer › Backing Up A Database To Use In Another Database.
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?
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.