SQL Server

kruelintent · #1 (**permalink**) 05-03-07, 10:39 AM

Hi. I have enterprise manager at home and it would be REALLY useful to administer my database from there. This would enable me to develop the site off the LIVE DB too which would be mighty handy.

Is there anyway this is possible?

Thanks in advance.
Kruel. (Tom)

jon123 · #2 (**permalink**) 05-03-07, 10:47 AM

Hi tom, I am not sure what Enterprise manager is but if you are refering to having something like mysql databases running on your home pc then yes you can.

There are many ways to do this, IIS, downloading various available software (search google). I use something called uniformserver.com/ which is a small download and creates a server on your pc which includes php, perl, mysql, etc.

**Administrator** · #3 (**permalink**) 05-03-07, 11:25 AM

Hello Tom,

You can connect to your MSSQL database using Enterprise Manager. All you need to do is include database name, username and password and you can make connection to your live DB.

kruelintent · #4 (**permalink**) 05-03-07, 11:39 AM

Hi, thanks,

Don't I need to give it a URL too somehow?

The database is on your severs and the Enterprise Manager is on my machine...

Sorry if I am missing something obvious.

Thanks
Tom.

**Administrator** · #5 (**permalink**) 05-03-07, 11:47 AM

Yep. IP address of the server has to be included. Without that your enterprise manager will search for the database on your machine and not our server

kev woodman · #6 (**permalink**) 05-03-07, 12:47 PM

This is a really useful thing to be able to do as well. I have to work off a development server that doesn't allow me to create remote MySQL users (i.e. I can only create user@localhost) and it's a pain in the arse keeping local development servers synced with the remote ones.

jon123 · #7 (**permalink**) 05-03-07, 01:34 PM

sorry, maybe i should google before I offer advice in future

kev woodman · #8 (**permalink**) 05-03-07, 01:36 PM

I don't know what Enterprise manager is

- is it any good (I'm just too lazy to Google it).

kruelintent · #9 (**permalink**) 05-03-07, 03:15 PM

That works like a charm. Thanks all.

**Administrator** · #10 (**permalink**) 05-03-07, 07:50 PM

Quote:

Originally Posted by jon123

sorry, maybe i should google before I offer advice in future

Thats not a problem. Your reply was much better than some of our staff members would have done. At least you were aware of what you typing

**Administrator** · #11 (**permalink**) 05-03-07, 07:52 PM

Quote:

Originally Posted by kev woodman

I don't know what Enterprise manager is

- is it any good (I'm just too lazy to Google it).

Enterprise Manager is like PHPMyAdmin. You use PHPMyAdmin for development of mysql database and some customers use Enterprise Manager for development of MSSQL database.

Working and structure of both databases is completely different so only google wont help.

kev woodman · #12 (**permalink**) 05-03-07, 10:01 PM

Ah I see - thanks Admin