I've spent a lot of time into (crappy)coding some converters from mysql to access (and viceversa) while in internet we have already such tools and those dbms have already some basic features to export the whole databases in an human readable and easy to use format.
I've found that the biggest problem is the lack of decent tools to export mssql.
Since I'm quite busy I've hoped to find an easy solution (tool) to export the all the databases of a mssql express server in a simple sql text file.
I know that I can use "osql" to do a backup but I needed a damn sql text file with the structure and the data just to modify by hand several things and to understand also different kinds of queries and then restore the database in an error-free manner.
After a whole day I've found only a single decent tool that have worked efficiently and it's
EMS MS SQL Manager Lite
The lite version is free and it's good for a basic administration of an express version of MSSql.
If you have a full version of MSSql (€€€ $$$) you can export in several formats the database(s) by using the administration tools. The problem is that you need to own a software
----
Other generic free tools for the administration of MSSql (express)
DbaMgr
DbaMgr2k
http://www.asql.biz/en/Download.aspx#DbaMgr
osql batch database extractor (doesn't work as expected)
http://www.rs-freeware.org/osql/#install
Java client (I don't have java installed on the server and I had not the time to upload the jre, so I don't know if it's a good tool or not.
http://squirrel-sql.sourceforge.net/
-------
Suggestions about other tools are welcome.
I've found that the biggest problem is the lack of decent tools to export mssql.
Since I'm quite busy I've hoped to find an easy solution (tool) to export the all the databases of a mssql express server in a simple sql text file.
I know that I can use "osql" to do a backup but I needed a damn sql text file with the structure and the data just to modify by hand several things and to understand also different kinds of queries and then restore the database in an error-free manner.
After a whole day I've found only a single decent tool that have worked efficiently and it's
EMS MS SQL Manager Lite
The lite version is free and it's good for a basic administration of an express version of MSSql.
If you have a full version of MSSql (€€€ $$$) you can export in several formats the database(s) by using the administration tools. The problem is that you need to own a software
----
Other generic free tools for the administration of MSSql (express)
DbaMgr
DbaMgr2k
http://www.asql.biz/en/Download.aspx#DbaMgr
osql batch database extractor (doesn't work as expected)
http://www.rs-freeware.org/osql/#install
Java client (I don't have java installed on the server and I had not the time to upload the jre, so I don't know if it's a good tool or not.
http://squirrel-sql.sourceforge.net/
-------
Suggestions about other tools are welcome.
Comments
Post a Comment