Code to manage databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 10 Jul 2007 22:00 GMT

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!

Reply to this Message

Bob Barrows [MVP] - 10 Jul 2007 22:33 GMT

> 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?
[quoted text clipped - 7 lines]
> primary host does not allow connections to SQL server from outside
> their network.

http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html

Signature

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.

Reply to this Message

Adrienne Boswell - 11 Jul 2007 20:46 GMT

> 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?
[quoted text clipped - 9 lines]
>
> Thanks!

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

Signature

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

Reply to this Message

Dave - 15 Jul 2007 18:45 GMT

> > 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?
[quoted text clipped - 11 lines]
> 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.

Reply to this Message

Webmaster Forum / ASP / Database Access / July 2007

Code to manage databases