I'm searching for a tool to dump a database including DDL and content as plain SQL-Sсript, so that it can be archived in a plain text format. I know e.g. the Oracle dump tools or MySQL dump, but is there a tool which can connect to different data sources and get the job done? GUI would be great.
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效,请关闭广告屏蔽插件后再试):
问题:
回答1:
Check out http://squirrel-sql.sourceforge.net/. Gui, cross-platform and supports any database with jdbc driver.
回答2:
Look at set of SSMA Microsft's free tools (Oracle, Sybase, MySQL..) http://www.microsoft.com/sqlserver/2005/en/us/Migration-oracle.aspx