Code to manage databases

Code to manage databases

am 10.07.2007 23:00:20 von dave

I am moving to the MS SQL environment from MySQL and I was wondering if
there is any ASP code out there to manage databases?

In MySQL there is PhP code that allows you to view all databases you
have access to. Create new databases. View all tables in a database,
create/manage new tables. And perform queries.

I know that I can do this stuff in either Enterprise Manager and/or
Query Analyzer, but I'm looking for a web based solution since our
primary host does not allow connections to SQL server from outside their
network.

Thanks!

Re: Code to manage databases

am 10.07.2007 23:33:40 von reb01501

Dave wrote:
> I am moving to the MS SQL environment from MySQL and I was wondering
> if there is any ASP code out there to manage databases?
>
> In MySQL there is PhP code that allows you to view all databases you
> have access to. Create new databases. View all tables in a database,
> create/manage new tables. And perform queries.
>
> I know that I can do this stuff in either Enterprise Manager and/or
> Query Analyzer, but I'm looking for a web based solution since our
> primary host does not allow connections to SQL server from outside
> their network.
>
http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sq l-server/msde.html

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Code to manage databases

am 11.07.2007 21:46:59 von Adrienne Boswell

Gazing into my crystal ball I observed Dave writing in
news:MPG.20fdaf322b90ba79989680@news.west.cox.net:

> I am moving to the MS SQL environment from MySQL and I was wondering if
> there is any ASP code out there to manage databases?
>
> In MySQL there is PhP code that allows you to view all databases you
> have access to. Create new databases. View all tables in a database,
> create/manage new tables. And perform queries.
>
> I know that I can do this stuff in either Enterprise Manager and/or
> Query Analyzer, but I'm looking for a web based solution since our
> primary host does not allow connections to SQL server from outside
their
> network.
>
> Thanks!
>

Google for MyLittleAdmin - not tested, but looks like it might be what
you want.



--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

Re: Code to manage databases

am 15.07.2007 19:45:58 von dave

In article ,
arbpen@yahoo.com says...
> Gazing into my crystal ball I observed Dave writing in
> news:MPG.20fdaf322b90ba79989680@news.west.cox.net:
>
> > I am moving to the MS SQL environment from MySQL and I was wondering if
> > there is any ASP code out there to manage databases?
> >
> > In MySQL there is PhP code that allows you to view all databases you
> > have access to. Create new databases. View all tables in a database,
> > create/manage new tables. And perform queries.
> >
> > I know that I can do this stuff in either Enterprise Manager and/or
> > Query Analyzer, but I'm looking for a web based solution since our
> > primary host does not allow connections to SQL server from outside
> their
> > network.
> >
>
> Google for MyLittleAdmin - not tested, but looks like it might be what
> you want.

Thanks, I found it at www.mylittletools.net

However, $590 is a bit outside my budget and the Lite version doesn't do
half what I need.

I'll keep looking.