SEO

#1 (**permalink**) 02-28-2008, 07:26 PM

Hello, I am new to MS SQL database and have recently downloaded MSDE (Coming
in from an Oracle background). I have installed it and have a couple of
questions.

1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE)
where you can log on to the database and view tables/data/views and so on?

2.) I need to set up an account with a username/password. Is there a
executable that I require to be able to perform this task?

3.) I see Enterprise manager on microsoft website, but is that shipped with
MSDE?

I know that these may sound simple, but I would appreciate your comments.

Kind regards,

Harry.

#2 (**permalink**) 02-28-2008, 07:26 PM

Harry,

MSDE comes with Osql command line utility that you can use to interact with your
server. Unfortunately, MSDE does not come with any UI tool.

Andrea has done a great job at getting a free UI tool for you. You can get more
info at http://www.asql.biz/DbaMgr.shtm
If you're already familiar with T-SQL, you can use our free tool, QALite from
site.

--
-oj
http://www.rac4sql.net

"Harry J" <xx@yy.com> wrote in message news:5B6Lb.20979$ts4.2084@pd7tw3no...
> Hello, I am new to MS SQL database and have recently downloaded MSDE (Coming
> in from an Oracle background). I have installed it and have a couple of
> questions.
>
> 1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE)
> where you can log on to the database and view tables/data/views and so on?
>
> 2.) I need to set up an account with a username/password. Is there a
> executable that I require to be able to perform this task?
>
> 3.) I see Enterprise manager on microsoft website, but is that shipped with
> MSDE?
>
> I know that these may sound simple, but I would appreciate your comments.
>
> Kind regards,
>
> Harry.
>
>

#3 (**permalink**) 02-28-2008, 07:29 PM

Hi

You may want to check out:
http://vyaskn.tripod.com/oracle_sql_...quivalents.htm
http://msdn.microsoft.com/library/de...oracle2sql.asp

John

"Harry J" <xx@yy.com> wrote in message news:5B6Lb.20979$ts4.2084@pd7tw3no...
> Hello, I am new to MS SQL database and have recently downloaded MSDE
(Coming
> in from an Oracle background). I have installed it and have a couple of
> questions.
>
> 1.) Is there a product something like SQLPLUS (hopefully shipped with
MSDE)
> where you can log on to the database and view tables/data/views and so on?
>
> 2.) I need to set up an account with a username/password. Is there a
> executable that I require to be able to perform this task?
>
> 3.) I see Enterprise manager on microsoft website, but is that shipped
with
> MSDE?
>
> I know that these may sound simple, but I would appreciate your comments.
>
> Kind regards,
>
> Harry.
>
>

#4 (**permalink**) 02-28-2008, 07:30 PM

Hi Harry,

I see that TOAD now comes with a freeware version for SQL Server. I
haven't tried it, but I presume you could use it to connect to MSDE.

Coming from an Oracle background you may have used TOAD before so it
could give you a leg up.

http://toadsoft.com

Peter

"Harry J" <xx@yy.com> wrote in message news:<5B6Lb.20979$ts4.2084@pd7tw3no>...
> Hello, I am new to MS SQL database and have recently downloaded MSDE (Coming
> in from an Oracle background). I have installed it and have a couple of
> questions.
>
> 1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE)
> where you can log on to the database and view tables/data/views and so on?
>
> 2.) I need to set up an account with a username/password. Is there a
> executable that I require to be able to perform this task?
>
> 3.) I see Enterprise manager on microsoft website, but is that shipped with
> MSDE?
>
> I know that these may sound simple, but I would appreciate your comments.
>
> Kind regards,
>
> Harry.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

MSDE questions.