Using EMS SQL Server Manager to manage your Arvixe databases
Written by Rick Hubka Saturday, 11 December 2010
If you CRUD your SQL Server database, this may interest you.
BTW, CRUD stands for Create / Read / Update / Delete
What I really mean is: For those who need full access to their database to view and edit data, tables, views, stored procedures, export data, export database objects, import data and more, There are database tools available that allow you to access your remote SQL Server databases on your Arvixe hosting. As a developer of Custom mojoPortal modules, I use tools like this daily and the tool I use most is EMS SQL Server Manager which available here. I also use it to manage all the local SQL Server databases on my PC, laptop and the company Network Servers.
EMS have commercial and non-commercial licenses available. For personal home use I have a non-commercial license which has all the same features as the commercial product. More on pricing here. There is also a Lite version which is free and somewhat restricted, but maybe that’s all you need. Compare Full and Lite versions here.
After installing EMS SQL Manager it can’t do anything much for you until you register a local or remote Host and then you must register databases for that Host. Lets register a Host account to your Arvixe server. My Arvixe server name is violet.arvixe.com. Check your initial Arvixe emails for one titled “Hosting Account Information”. Just a few lines from the top it says “Server Name: “. That’s the name you use.
This opens up the “Register Database Wizard” window as seen below. Enter your arvixe server name. Then select the SQL Server authentication radio button. The enter the user name and password for this SQL Server database on your Arvixe hosting package like below. I unchecked “Register a single database” because I am going to register several databases at once in this tutorial. Then click the “Next” button.
Please be patient and wait. This may take a minute or 2.
Below is the next window for selecting one or more databases.
WOW!!! Look at all those database names. The list of Available databases is not just your database(s). It’s a list of all the SQL Server databases on server name violet.arvixe.com. SQL Database tools don’t have the ability to filter database list by User and password so they show all databases. Don’t worry, nobody can view or edit a database unless the User Name and Password are for that database is entered.
Scroll through the left database list and click on your database name and then click the right arrow button to move the database name to the Selected databases list on the right. When you have selected your database(s), click the “Next” button.
Below is the next window. In this options window. I accept the default values listed and do nothing on this window. You may want to change one or more of the settings in this window.
Yes we are finished as seen below.
With the setup complete your database(s) will be listed in the left pane as shown above.
In the left panel, Double Click on the name of the database you would like to open. Wait. Then under Schema there will be a user listed and under that will be a list of your tables, views, stored procedures, etc. Go ahead and double click on a table name and the tables details will open in the larger right pane ready for you to edit data or add new table names.
I’m not going into the details of how EMS SQL Server Manager works. That’s beyond the scope of this tutorial. I will say…”I love this Tool”. I have been using it for 7 years now. Yes, I can connect to my database at violet.arvixe.com using MS Visual Studio. That works fine but that Server Explorer is not near as robust as the EMS tool.
Wait time for connecting will depend mostly on the speed of your internet connection.
Take Care and Happy Hosting.