Friday, March 9, 2012

MSDE

How does MSDE handle data mangement? Does it come with sql analyser or some sort of database manager?
Thanks.I don't believe it comes with anything. I think the general idea is that you develop it using the tools you mention and then ship the MSDE like you would an runtime Access database.|||pkr hit it on the nose. If you are using MSDE in conjunction with ASP.NET Web Matrix, you would use Web Matrix's built-in database management tool. If you are using MSDE with Microsoft Access you would use Accesss for the database management.

Some other options for managing MSDE:
-- using the built-in OSQL command line utility:HOW TO: Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility

--ASP.Net EnterpriseManager

--Web Data Administrator

--ASP.NET Web Matrix includes a database management tool

-- SQL Enterprise Manager and Query Analyzer -- the SQL Server 2000 client tools (note that there are licensing requirements)

-- there are other 3rd party tools such as "MSDE Manager" and "MyLittleAdmin"

Terri|||My main need is maintaining data tables, stored procs, triggers, udf etc...
What tool would allow me to edit stored procs, triggers, udf specifically?
Thanks again.|||You would have to investigate that to see which tool met your needs.

To the best of my knowledge, only SQL Enterprise Manager and Query Analyzer would enable you to everything you are looking for.

Terri|||Query Analyzer and Enterprise Manager are really what you're looking for. I know you can now buy SQL Server Developer Edition for $49 and it comes with both Query Analyzer and Enterprise Manager.

If you don't want to spend the money you can go with the open source, Query Analyzer like tool called SqlBuddy. Here's the link, http://sqlbuddy.sourceforge.net/.

Good luck.

No comments:

Post a Comment