MS SQL Manager
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=6415
Printed Date: 30 March 2026 at 4:29am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MS SQL Manager
Posted By: spikeashlye
Subject: MS SQL Manager
Date Posted: 14 October 2003 at 4:21pm
| Ok, I'm going to try the MS SQL verison of this forum. Can someone tell me what a good (free is better) manager for MS SQL is? Is there a MSSQL Front, that works like MySQL Front? I cannot get the Microsoft manager, because I dont have any way to get the Developer Edition of SQL Server right now. I know that the trial version also includes the manager, and the tools don't expire, but I have dialup and downloading it would take forever. |
Replies:
Posted By: DaFool
Date Posted: 14 October 2003 at 4:27pm
| I use a program a friend of mine coded for him so that he wouldn't have to use the slow Enterprise Manager. It's called DBManager. I will ask if he will let me send it out to folks. |
Posted By: Bliss
Date Posted: 14 October 2003 at 7:01pm
|
I've used WinSQL and ASPEnterpriseManager (Actually an ASP script!) ------------- Hehehe... |
Posted By: spikeashlye
Date Posted: 15 October 2003 at 6:41pm
|
Wow. That WinSQL program seems like a dream come true. Downloading it now. If it can actaully power MS SQL and MySQL all in the same application it's well worth the money. Thanks! |
Posted By: Bunce
Date Posted: 15 October 2003 at 11:46pm
|
MS have just released a free: web-based 'enterprise manager', that looks OK. Cheers, ------------- There have been many, many posts made throughout the world... This was one of them. |
Posted By: spikeashlye
Date Posted: 16 October 2003 at 12:10am
Greate! I'll check that out too. I'm not having much luck with the WinSQL program, so right now I'm just using Microsoft Access 2002 with MSDE to connect to the MS SQL database, and so far it's working greate! Seing as how the sql_setup file generates all the tables via code. I still have all the basic features, I think my only downfall is not being able to backup the database. Thanks for the help! Edit: Actually I just gave it another swing, and got the WinSQL Professional running. It looks like everythings working correctly, but I want to make sure I'm doing things right, seeing as I'm just starting with MS SQL and I've never used WinSQL before. The most important thing to me is being able to backup my database 100%, I want everything backed up, structure and data. Can I get some information on how to do this via WinSQL. I checked there help documents but it dosen't look like there all that detailed... at least the ones that I found. |
Bunce wrote:Posted By: huwnet
Date Posted: 16 October 2003 at 11:37am
I am going to try out the SQL version of WWF 7.5 now. All my hosting oackages only support access though! 
|
Posted By: Tegwin
Date Posted: 16 October 2003 at 5:01pm
|
One of the best I have used, which I posted in the database section of
this forum is called DBAMGR2k..It is FANTASTIC. It allows you to use
MSDE7/2000 and SQL7/2000. It has full source code in Visual Basic. http://www.asql.biz/DbaMgr/DownLoad2k.shtm - http://www.asql.biz/DbaMgr/DownLoad2k.shtm ------------- If you dont want my peaches, dont shake my tree |
Posted By: spikeashlye
Date Posted: 16 October 2003 at 5:59pm
|
vb code is greate. i could debug that in a hart beat. I dont think it works on windows xp, because i continue getting errors: "DLL's not found, check for supported operating systems" on this line, Public objServer As SQLDMO.SQLServer2 I don't know, but I don't have a lot of time to play with it right now. |
Posted By: Bunce
Date Posted: 17 October 2003 at 12:02am
|
I'd guess you don't have the DMO component(s) installed. You can probably get them from MS somewhere, or it would come with the client tools if you can get a copy (but then, why would you need this right!).
------------- There have been many, many posts made throughout the world... This was one of them. |
Posted By: spikeashlye
Date Posted: 17 October 2003 at 1:16am
|
I'm just going to find someone with a high speed connection and download the trial version of MS SQL Server 7.0 for free. The developer tools like, Enterprise Manager do not expire and you can use them forever, MS even grants upgrades to them most of the time. The only thing that expires is the developer server... Thanks! |
Posted By: Bunce
Date Posted: 17 October 2003 at 1:19am
|
Really? Could you point me to the link at MS which says that? Cheers, ------------- There have been many, many posts made throughout the world... This was one of them. |
Posted By: spikeashlye
Date Posted: 17 October 2003 at 1:36am
It's almost 3am here, and I'm going to get some sleep. Got work in the morning... I'm going to try and use one of our webservers to download it tomorrow, I'll jump on sometime and post the link. |
