473,322 Members | 1,566 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

SQL-2000 GUI

Good morning:

At least it's morning where I am. :)

I have a rather newbie question I'm afraid. I have VisualStudio.NET, and
have installed it along with SQL server. However I can't seem to find an
administration front-end to SQL, other than the VisualStudio, which is
ok for creating databases and adding tables/columns. However when I go
to generate create script, I'm told that I need client tools.

I've installed everything from the cd's - am I missing something very
obvious, and/or how does one import scripts?

Thanks for reading.

--
Regards
================================================== =========================
Try to get all of your posthumous medals in advance.
Jul 20 '05 #1
10 6706
Hi.. We can generate scripts of objects in SQL server using Enterprise
Manager.

For more info refer the following link

http://msdn.microsoft.com/library/de.../en-us/entrmgr
/agent_067n.asp

Thanx
Srinivas Sampangi

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #2
Dagwood ("Dagwood Bumstead"@antionline.com) writes:
Good morning:

At least it's morning where I am. :)
Good Evening to you! :-)
I have a rather newbie question I'm afraid. I have VisualStudio.NET, and
have installed it along with SQL server. However I can't seem to find an
administration front-end to SQL, other than the VisualStudio, which is
ok for creating databases and adding tables/columns. However when I go
to generate create script, I'm told that I need client tools.

I've installed everything from the cd's - am I missing something very
obvious, and/or how does one import scripts?


With VS.Net you get MSDE, and MSDE does not come with any other
administration tools than OSQL which is a command-line tool. To get
the fancy stuff, you need to buy an SQL Server license.

But don't despair. MS has announced that from Aug 1st the price for
Developer Edition will be slashed to 49 USD. (The current price is
about 10 as high.) In the mean while, you can download the Evaluation
Edition of SQL Server from www.microsoft.com/sql. It is good for 120
days.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3
In comp.databases.ms-sqlserver, Srinivas Sampangi wrote:
Hi.. We can generate scripts of objects in SQL server using Enterprise
Manager. For more info refer the following link http://msdn.microsoft.com/library/de.../en-us/entrmgr
/agent_067n.asp

Hi Srinivas:

Thanks for the link (I've bookmarked it) - however, my main issue is
that I can't find Enterprise Manager -- I have VisualStudio.NET 5 cd's
in total. (SQL 2000 comes with it) I installed *everything*, but I can't
find Enterprise Manager. I even went back to the cd's, to see if I could
update the install, there isn't anything to update.

So, after creating my db/tables in VisualStudio, I now wish to run these
scripts to populate the tables, as it's too much data to enter by hand.

Suggestions?

--
Regards
================================================== =========================
You should emulate your heros, but don't carry it too far. Especially
if they are dead.
Jul 20 '05 #4
In comp.databases.ms-sqlserver, Erland Sommarskog wrote:
Dagwood ("Dagwood Bumstead"@antionline.com) writes:
Good morning: At least it's morning where I am. :)
Good Evening to you! :-)
Evening.
I have a rather newbie question I'm afraid. I have VisualStudio.NET, and
have installed it along with SQL server. However I can't seem to find an
administration front-end to SQL, other than the VisualStudio, which is
ok for creating databases and adding tables/columns. However when I go
to generate create script, I'm told that I need client tools. I've installed everything from the cd's - am I missing something very
obvious, and/or how does one import scripts?

With VS.Net you get MSDE, and MSDE does not come with any other
administration tools than OSQL which is a command-line tool. To get
the fancy stuff, you need to buy an SQL Server license.
Hmm, well I have an SQL server with SQL service manager, is this MSDE?
What does the acronymn MSDE stand for?

I don't mind using a term and CLI, but I can use VStudio can I not for
this, in terms of importing data? I've already created the database and
tables...
But don't despair. MS has announced that from Aug 1st the price for
Developer Edition will be slashed to 49 USD. (The current price is
about 10 as high.) In the mean while, you can download the Evaluation
Edition of SQL Server from www.microsoft.com/sql. It is good for 120
days.


Amazing that one would need to pay for the developer edition -- don't
developers encourage the use of products by third parties? ;)

Thanks for responding.

--
Regards
================================================== =========================
Be careful of reading health books, you might die of a misprint.
-- Mark Twain
Jul 20 '05 #5
Dagwood ("Dagwood Bumstead"@antionline.com) writes:
Hmm, well I have an SQL server with SQL service manager, is this MSDE?
What does the acronymn MSDE stand for?
MSDE is the desktop edition of MS SQL Server. It comes with a bunch of
products, VS and Office Developer are two examples. You can also build
an application that uses MSDE and redistribute freely.
I don't mind using a term and CLI, but I can use VStudio can I not for
this, in terms of importing data? I've already created the database and
tables...


If the command-lines are there, you should have BCP as well. That's
good for import. If you have MSDN Library, you should have all SQL
documentation there. Else, check my signature.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #6
In comp.databases.ms-sqlserver, Erland Sommarskog wrote:
Dagwood ("Dagwood Bumstead"@antionline.com) writes:
Hmm, well I have an SQL server with SQL service manager, is this MSDE?
What does the acronymn MSDE stand for?
MSDE is the desktop edition of MS SQL Server. It comes with a bunch of
products, VS and Office Developer are two examples. You can also build
an application that uses MSDE and redistribute freely. I don't mind using a term and CLI, but I can use VStudio can I not for
this, in terms of importing data? I've already created the database and
tables...

If the command-lines are there, you should have BCP as well. That's
good for import. If you have MSDN Library, you should have all SQL
documentation there. Else, check my signature.


Ok thanks, (I apologize in advance for being thick headed), but you
haven't really answered my question. First, what I've got is NOT called
MSDE, I don't have anything on my install disk or on my hard drive
called that. It says SQL server, explicitly. You're saying that MSDE is
NOT referred to as SQL server or is? Why would it be called SQL server,
if in fact it isn't MS-SQL? Second, if one can create tables in
VisualStudio, surely one can import data -- is this too far fetched, or
am I totally off base here, without using a terminal? I use a terminal,
but I'm trying to figure out why I need VisualStudio.NET, as I have
independent apps that I use in WebDevelopment, I'm not an application
developer, I simply create dynamic websites.

I guess I should go back to PostreSQL, at least I have the whole
application.

--
Regards
================================================== =========================
You have been selected for a secret mission.
Jul 20 '05 #7
I'm don't know what version/edition of VS.NET you have but it may come
with Server Explorer. This IDE tool provides much of the functionality
as the SQL Server GUI tools but with a developer focus. If installed,
you can launch it from within your IDE via the View menu.

SQL Server 2000 comes in 5 editions, including SQL Server 2000 Desktop
Engine. MSDE was renamed the SQL Server 2000 Desktop Engine. You can
peruse the white paper at
<http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp> to
see the differences. A couple of relevant excerpts:

<Excerpt>
The SQL Server 2000 Desktop Engine does not include graphical management
tools; the application distributing the engine is usually coded to
perform any needed database administration. You can manage instances of
the Desktop Engine from the SQL Server 2000 graphical tools if installed
with another edition of SQL Server.
</ Excerpt>

<Excerpt>
SQL Server 2000 Developer Edition
This edition allows developers to build any type of application on top
of SQL Server. It includes all of the functionality of Enterprise
Edition but with a special development and test end-user license
agreement (EULA) that prohibits production deployment (for complete
details, see the SQL Server 2000 Developer Edition EULA at
http://www.microsoft.com/sql.
</ Excerpt>

I believe the SQL Server 2000 Developer Edition (which includes GUI
tools) is included with MSDN Enterprise and Universal subscriptions. If
you VS.NET installation is part of those MSDN subscriptions, you are
licensed to use the SQL Developer edition from your MSDN media. SQL
Server 2000 Developer edition can also be purchased separately.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Dagwood" <"Dagwood Bumstead"@antionline.com> wrote in message
news:sl****************************@3D.AliasWavefr ont.ca...
In comp.databases.ms-sqlserver, Erland Sommarskog wrote:
Dagwood ("Dagwood Bumstead"@antionline.com) writes:
Hmm, well I have an SQL server with SQL service manager, is this MSDE? What does the acronymn MSDE stand for?
MSDE is the desktop edition of MS SQL Server. It comes with a bunch of products, VS and Office Developer are two examples. You can also build an application that uses MSDE and redistribute freely. I don't mind using a term and CLI, but I can use VStudio can I not for this, in terms of importing data? I've already created the database and tables...

If the command-lines are there, you should have BCP as well. That's
good for import. If you have MSDN Library, you should have all SQL
documentation there. Else, check my signature.


Ok thanks, (I apologize in advance for being thick headed), but you
haven't really answered my question. First, what I've got is NOT

called MSDE, I don't have anything on my install disk or on my hard drive
called that. It says SQL server, explicitly. You're saying that MSDE is NOT referred to as SQL server or is? Why would it be called SQL server, if in fact it isn't MS-SQL? Second, if one can create tables in
VisualStudio, surely one can import data -- is this too far fetched, or am I totally off base here, without using a terminal? I use a terminal, but I'm trying to figure out why I need VisualStudio.NET, as I have
independent apps that I use in WebDevelopment, I'm not an application
developer, I simply create dynamic websites.

I guess I should go back to PostreSQL, at least I have the whole
application.

--
Regards
================================================== ======================
=== You have been selected for a secret mission.

Jul 20 '05 #8
Which version of VS did you get? Vs Enterprise and above should contain a
copy of SQL Server developer edition. This should have installed a separate
program group which contains EM and other tools.

Search your machine for isqlw.exe, this is one of the graphical tools. If
its not there then go back to the SQL Server CD thats part of the VS install
and re-run the installer, making sure you select client components.

"Dagwood" <"Dagwood Bumstead"@antionline.com> wrote in message
news:sl****************************@3D.AliasWavefr ont.ca...
In comp.databases.ms-sqlserver, Erland Sommarskog wrote:
Dagwood ("Dagwood Bumstead"@antionline.com) writes:
Hmm, well I have an SQL server with SQL service manager, is this MSDE?
What does the acronymn MSDE stand for?
MSDE is the desktop edition of MS SQL Server. It comes with a bunch of
products, VS and Office Developer are two examples. You can also build
an application that uses MSDE and redistribute freely. I don't mind using a term and CLI, but I can use VStudio can I not for
this, in terms of importing data? I've already created the database and
tables...

If the command-lines are there, you should have BCP as well. That's
good for import. If you have MSDN Library, you should have all SQL
documentation there. Else, check my signature.


Ok thanks, (I apologize in advance for being thick headed), but you
haven't really answered my question. First, what I've got is NOT called
MSDE, I don't have anything on my install disk or on my hard drive
called that. It says SQL server, explicitly. You're saying that MSDE is
NOT referred to as SQL server or is? Why would it be called SQL server,
if in fact it isn't MS-SQL? Second, if one can create tables in
VisualStudio, surely one can import data -- is this too far fetched, or
am I totally off base here, without using a terminal? I use a terminal,
but I'm trying to figure out why I need VisualStudio.NET, as I have
independent apps that I use in WebDevelopment, I'm not an application
developer, I simply create dynamic websites.

I guess I should go back to PostreSQL, at least I have the whole
application.

--
Regards

================================================== ========================= You have been selected for a secret mission.

Jul 20 '05 #9
In comp.databases.ms-sqlserver, Daniel Bush wrote:
On Sun, 27 Jul 2003 11:06:20 -0400, Dagwood <"Dagwood
Bumstead"@antionline.com> wrote:
[snip]
I guess I should go back to PostreSQL, at least I have the whole
application.

What MSDE is is a sort of SQL Server Light - it has nearly all of the
functionality of SQL Server (with a limited number of allowable
concurrent connections) but none of the fancy GUI tools. It is
intended to be a redistributable version of SQL Server: Microsoft
allows it to be distributed free with applications. So, as a
developer, you can actually distribute applications with their own
little SQL Server engine. To protect their marketability of the full
version of SQL Server, they don't give you all the tools or the GUI.
However, with the command line interface, you can replicate a
surprising percentage of the full version. Personally, I think it was
a pretty cool thing that Microsoft did - it is a more robust solution
for single user database apps than using Access mdb's, anyway. You
*do* have the whole version of MSDE - it is just a "light" version of
SQL Server, though I would agree it is not nearly as convenient to
use.


Great, thanks a lot Dan, appreciate the info, and thanks to everyone
else as well.

[snip]

--
Regards
================================================== =========================
Q: What's buried in Grant's tomb?
A: A corpse.
Jul 20 '05 #10
In comp.databases.ms-sqlserver, Carlos Fandango wrote:
Which version of VS did you get? Vs Enterprise and above should contain a
copy of SQL Server developer edition. This should have installed a separate
program group which contains EM and other tools. Search your machine for isqlw.exe, this is one of the graphical tools. If
its not there then go back to the SQL Server CD thats part of the VS install
and re-run the installer, making sure you select client components.


Great info -- no I don't have it, neither is there 'client tools' on the
disks. So, it appears I have MSDE. Now, I'm confident that I don't,
prior, I wasn't 100% sure.

Thanks!

--
Regards
================================================== =========================
Don't Worry, Be Happy.
-- Meher Baba
Jul 20 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Peter | last post by:
I run most of my SQL scripts via kornshell on AIX. I use the "here-document" to run some of the smaller ones. Example: #!/bin/ksh # Analyze the table. sqlplus...
0
by: Jan | last post by:
I store sql-commands in a database table. In the first step I get the sql command out of the database table with embedded sql. In the second step I try to execute the command, which i got from the...
9
by: Grim Reaper | last post by:
My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I have never setup a server from the beginning, so I am a little new at creating server groups. Alright, I am trying to create...
13
by: Jeager | last post by:
Why is it, Microsoft manage to write operating systems and office applications with every bell and whistle facility known to man. Yet, even after years and years of development they still cannot...
1
by: Peter | last post by:
I've purchased VS.NET 2005 Standard and have tried to install SQL Server 2005 Express, but get the following error in the error log. Please could someone help me.... Microsoft SQL Server 2005...
6
by: sghi | last post by:
Hi All, I'm new to this group and quite new to access/vba. So, shortly after beginning to write a simple application for my wife, I came across a blocking problem: I need to intercept the sql...
16
by: Jeremy S. | last post by:
I'm about to install VS.NET 2005 and SQL Server 2005 on a new/clean development machine (XP Pro/SP2 etc). Is the order of installation important (i.e., which product should I install first)? ...
1
by: Ted | last post by:
I managed to get it installed OK, along side MS Visual Studio 2005 (with which I received it). During the install, I made sure I installed everything. I have developed a number of applications...
6
by: Fuzzydave | last post by:
I am back developing futher our Python/CGI based web application run by a Postgres DB and as per usual I am having some issues. It Involves a lot of Legacy code. All the actual SQL Querys are...
5
by: dbrother | last post by:
Access 2003 Win XP Pro SP3 Using SQL /ADO Recordsets in a Do Loop Hello, I'm using a random number generator based on an integer input from a user from a form that will get X number of random...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.