Read the directory
Start,
· Instructions for using my-SQLViewer
· Program installation and startup instructions
· Main interface of the program
The DataBase browser,
· Search the database
· Replication of stored procedures
· Comparison database
Today I send a database written by myself and often used auxiliary tool: my-SQLViewer
I prefer to use stored procedures, but I find that no matter SQL Server Management Studio Express or MySql all kinds of messy tools in daily development, some places are not convenient to use, or even some functions are missing, so this tool came into being.
The positioning of this tool is: 1. Auxiliary tools – so limited functionality, but to do the limited functionality as well as possible. 2. Support SqlServer and MySql
Back to the top
This program is designed as a helper for programmers, so it is assumed that the operating system environment in which you are running has all the required components installed and not provided with the installation package for this program.
This program requires the following components
1. The.net Framework 2.0
2. Install SQL Server or SQL Server Management Studio (2005/2008)
3. If the MySql plug-in is used, mysql.data.dll is required
This program provides the following functions
1. More convenient than official tools to view data tables, stored procedures, views, user function definition scripts.
2. Perform search functions in various script definitions, such as search for tables in which a field is used in stored procedures.
3. Compare database structure definitions.
4. Copy stored procedures, views, and user functions between two databases.
Use advice
Because this procedure is a website, therefore cannot leave browser software. For a smoother operating experience, it is recommended to use browsers like Opera, Firefox, Safari, and Chrome instead of Internet Explorer and ie-based “Sock Puppet” browsers (not that it does not support Internet Explorer, but its JS performance is poor).
Back to the top
The installation of the program should be simple, double-click the installation package, omit 53 words……
When you have installed the program, you can launch it from the Start menu. Now start it, don’t be surprised when you see the picture below, because this program is a web application using Asp.net 2.0, can not leave the browser to run, in order to let you have the best operating experience, the program does not choose your operating system in the default browser, but let you choose your favorite browser.
As an aside: The default browser may not be your favorite. This is my setup: Firefox by default, for debugging purposes, but Opera as my favorite.
If you don’t like seeing this dialog box every time, choose “Remember Settings.”
One more thing: If you chose to support for MySql while installing the plug-in, but your computer is not installed MySql data provider program, so the start for the first time, there will be a plug-in loading failure error, can regardless of it, just click “go to tools home page,” of course you can also to choose the “I know these questions, Don’t tell me next time “, so it won’t be prompted next time. (Settings are saved in cookies)
If you have chosen to install the MySql plug-in, but it does not work properly, you can:
1. Install the MySql data provider program or copy mysql.data. DLL to the bin directory of the website
2. Find bin directory sites, direct delete MySqlViewer. Plugin. MySql. DLL
No matter which of the two methods you choose, a final restart of the program is required. Note: after the program runs, there will be an icon in the system tray area, please right click on the icon, and then choose to exit the program.
Back to the top
The following image is what you should see when the program starts properly.
For the first time, click the “New Connection” button to create a connection to the database, as shown below
Once you have created a connection, you can select one and click open Connection. Check it out.
Back to the top
In this interface, all databases accessed by the current connection will be displayed, along with the definition of objects such as tables, views, stored procedures, and custom functions for each database. The interface operation mode is also similar to the common desktop programs: with multi-tab browsing function, with a variety of convenient right-click menu functions.
Back to the top
You can select a node from the left tree control of the interface shown in the above image, right click, and choose “Search in database”, the following dialog box will appear:
Enter the keyword you are looking for and click OK. The result is shown below, and the program will highlight the matching line.
Back to the top
To demonstrate this functionality, you need to create a database. I created a database: XXXXXXXXXXX, which has no database objects, as shown below
Then, launch “Copy Stored Procedure” from the home screen, select database connection, database object, and click “Refresh List”, you will see the following results:
At this point, you can select the database object you want to copy, and then click the “Start Copying” button. Finally, we can look at the newly created database, as shown below:
Back to the top
In the main screen of the program, start “Compare Databases”, then select database connection, database object, click “Start Comparing Databases” button, you will see the following comparison results, in each database object definition, the first mismatched row is displayed as a highlighted line.
Click here to download the installation package.
Note: The tools described in this article are available in open source versions and can be read by clicking on the links below. 【 ASP.NET write a small tool SQLSERVER 】