Newbie - Accessing an existing DB thru MSDE

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

MSDE (2000)

Newbie - Accessing an existing DB thru MSDE

Author

Topic

tower
Starting Member

1 Post

Posted - 2002-09-23 : 17:19:49

I'm a newbie. Please be gentle.

I have a SQL2000 DB on a Win2000 SQL Server machine at work that I would like to save off and use on my home PC. My home PC has WinXP and VS.Net with MSDE. No SQL Server at home.

I would like to write programs at home that access this DB.

a) can I do this w/o buying SQL Developer or any other expensive product?

If so...
b) how do i backup the DB at work? Regular backup? Export data?
c) how do i restore the DB at home?
d) can I then just connect to it programmatically as if I had SQL Server at home?
e) do I then have access to Stored Procedures, tables, the whole kit-n-kaboodle?
f) are there any cheap substitute programs that perform Enterprise Manager functions? it seems like someone would have written a utility for us poor MSDE developers.

Like I said, I'm a newbie. :)

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-09-23 : 18:07:05

This should help you transfer a SQL Server database to an MSDE installation:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19664

Why not try the SQL Server 2000 evaluation?

http://www.microsoft.com/sql/evaluation/trial/default.asp

It gives you just about every feature as the full-blown version(s) do, only it stops running afte 120 days. You should still be able to use Enterprise Manager after that time, although I've never used it with MSDE and don't know if it works with it.

This might be helpful:

http://www.mylittletools.net/

Never tried it myself, and again it might not work with MSDE, but take a look.

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-09-23 : 18:08:33

Yes you can just backup your db at work and restore it at home (probably using WITH MOVE in the RESTORE command)
VS.NET has some UI for SQL doesn't it ? I've not got my copy yet but I have used the FREE WebMatrix and even that has simple table/database creation and stored procedure editing. MSDE has the command line tools e.g. osql through which you can run admin commands
There are a number of freebie EM like tools you can try e.g.
[url]http://utenti.lycos.it/asql/DownLoad.html[/url]

HTH
Jasper Smith

Doug G
Constraint Violating Yak Guru

331 Posts

Posted - 2002-09-23 : 20:00:52

quote:
f) are there any cheap substitute programs that perform Enterprise Manager functions? it seems like someone would have written a utility for us poor MSDE developers.

Access works pretty well if you have it.

Yes you can use Enterprise Manager against your MSDE server.

======
Doug G
======

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources