Request information regarding MSDE

  • Thread starter Thread starter _AnonCoward
  • Start date Start date
A

_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
 
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.
 
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
 
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
: >
: >
:
:
 
Back
Top