Request information regarding MSDE

[_AnonCoward]

I have an instance of MSDE on my system (installed with VS I presume)
and I want to start using it. As far as I can tell, there are no tools I
can use so I'm going to have to roll my own. The first thing I want to
do is figure out how to:

* connect to my server
* get a list of databases on that server
* retrieve a database from the server
* add a database to the server
* remove a database from the server

Any suggestions on how to proceed? If another ng is more appropriate for
this, plz advise.

TIA.

Ralf

 

[Robin Tucker]

Yes, try comp.databases.ms-sqlserver. But to answer your questions, in
Visual Studio, if you go to "server explorer", then it is possible to start
setting up and using databases from within the IDE.

 

[Kerry Moorman]

Ralf,

You can get started by using Visual Studio's Server Explorer. From the View
menu, choose Server Explorer. You should be able to do the things you listed
in your post from here.

You can also use Access's Upsizing Wizard to convert an Access database to
SQL Server.

Kerry Moorman

 

[_AnonCoward]

message : Yes, try comp.databases.ms-sqlserver. But to answer your questions,
in
: Visual Studio, if you go to "server explorer", then it is possible to
start
: setting up and using databases from within the IDE.


Thanx, I'll give that a shot.


Ralf


: : >I have an instance of MSDE on my system (installed with VS I presume)
: > and I want to start using it. As far as I can tell, there are no
tools I
: > can use so I'm going to have to roll my own. The first thing I want
to
: > do is figure out how to:
: >
: > * connect to my server
: > * get a list of databases on that server
: > * retrieve a database from the server
: > * add a database to the server
: > * remove a database from the server
: >
: > Any suggestions on how to proceed? If another ng is more appropriate
for
: > this, plz advise.
: >
: > TIA.
: >
: > Ralf
: >
: >
:
: