Skip to main content

MSSql or MSSqhell?

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.

Comments

Popular posts from this blog

Moodle 3.8.1+ - path leak via errors in several files

Moodle 3.8.1+ ----------------------------------------------- File: admin/mailout-debugger.php #!/usr/bin/php Notice : Disabled. in \admin\mailout-debugger.php on line 73 File: admin/settings/appearance.php Notice : Undefined variable: hassiteconfig in \admin\settings\appearance.php on line 10 Fatal error : Uncaught Error: Call to undefined function has_any_capability() in \admin\settings\appearance.php:10 Stack trace: #0 {main} thrown in \admin\settings\appearance.php on line 10 File: admin/settings/badges.php Notice : Undefined variable: hassiteconfig in \admin\settings\badges.php on line 30 Fatal error : Uncaught Error: Call to undefined function has_any_capability() in \admin\settings\badges.php:30 Stack trace: #0 {main} thrown in \admin\settings\badges.php on line 30 File: admin/settings/courses.php Notice : Undefined variable: hassiteconfig in \admin\settings\courses.php on line 32 Fatal error : Uncaught Error: Call to undefined function

2022 - Remove (the too many) Ads from Memu launcher

Simple method Download from pureapk "MEmu Launcher2" ex: MEmu Launcher2_v6.0.9_apkpure.com Install "System app remover" (root) remove from system apps the "memu launcher 2" import the "purified" MEmu Launcher2 apk with the Memu utility ("apk" on the right toolbar) Longer method Install "Export Apk" Export the memu launcher2  Install purify https://github.com/echo-devim/purify/raw/master/Purify.apk use purify with the exported memu launcher 2 Install "System app remover" (root) remove from system apps the "memu launcher 2" import the "purified" MEmu Launcher2 apk with the Memu utility ("apk" on the right toolbar)      

[FIX] cyberpunk skip dialogue disappeared - pc Y button

  open C:\Games\Cyberpunk 2077\r6\config\inputUserMappings.xml with a text editor (ex. notepad++)   find   <mapping name="SceneFastForward_Button" type="Button" > ... </mapping> example (my non working settings)     <mapping name="SceneFastForward_Button" type="Button" >         <button id="IK_Pad_DigitLeft" />         <button id="IK_Y" overridableUI="fastForward" />     </mapping> and REPLACE it with the following:     <mapping name="SceneFastForward_Button" type="Button" >         <button id="IK_Pad_B_CIRCLE" />         <button id="IK_C" overridableUI="fastForward"/>     </mapping> thanks to the vanilla xml files on nexus mods as the original source.