469,603 Members | 2,130 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

Using MSDE and moving databases

Hi all,

I am pretty new to dB programming and a have a few questions which I will
put in separate threads. I have only coded as a hobby and some limited work
projects. I have recently been asked if I could help implement a simple help
desk for work. This has only been running for a few weeks and the data is
currently being stored in excel (I know...I know!! :-)

I have installed a copy of MSDE on my development machine and plan on doing
the same on my office 'server'....in fact it may well already be on there. I
also have another testbed to act as the client.

My first question (in no particular order) is how to move the sql db from
the development machine to the server? I don't have any sql/db tools other
than anything that is included with MSDE (which I don't think is much).

I will be posting other Q's for any experts out there!

Thanks in advance.

Phil
Jul 23 '05 #1
2 2902

"Phil" <Ph**@nospam.com> wrote in message
news:d4**********@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
Hi all,

I am pretty new to dB programming and a have a few questions which I will
put in separate threads. I have only coded as a hobby and some limited
work projects. I have recently been asked if I could help implement a
simple help desk for work. This has only been running for a few weeks and
the data is currently being stored in excel (I know...I know!! :-)

I have installed a copy of MSDE on my development machine and plan on
doing the same on my office 'server'....in fact it may well already be on
there. I also have another testbed to act as the client.

My first question (in no particular order) is how to move the sql db from
the development machine to the server? I don't have any sql/db tools other
than anything that is included with MSDE (which I don't think is much).

I will be posting other Q's for any experts out there!

Thanks in advance.

Phil


Backup and restore is usually the easiest way - see BACKUP, RESTORE and
"Copying Databases" in Books Online, as well as this KB article:

http://support.microsoft.com/default...b;en-us;314546

You can use osql.exe to execute all the commands you need.

Simon
Jul 23 '05 #2
Thanks Simon,

Have completed the 1st part of this and detached the database ready for
copying to the new server. Thanks for your quick response.

There's no reason to think reattaching to the new server will be a problem,
only to be aware of the possible 'db owner' permission.

Cheers,

Phil

"Simon Hayes" <sq*@hayes.ch> wrote in message
news:42**********@news.bluewin.ch...

"Phil" <Ph**@nospam.com> wrote in message
news:d4**********@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
Hi all,

I am pretty new to dB programming and a have a few questions which I will
put in separate threads. I have only coded as a hobby and some limited
work projects. I have recently been asked if I could help implement a
simple help desk for work. This has only been running for a few weeks and
the data is currently being stored in excel (I know...I know!! :-)

I have installed a copy of MSDE on my development machine and plan on
doing the same on my office 'server'....in fact it may well already be on
there. I also have another testbed to act as the client.

My first question (in no particular order) is how to move the sql db from
the development machine to the server? I don't have any sql/db tools
other than anything that is included with MSDE (which I don't think is
much).

I will be posting other Q's for any experts out there!

Thanks in advance.

Phil


Backup and restore is usually the easiest way - see BACKUP, RESTORE and
"Copying Databases" in Books Online, as well as this KB article:

http://support.microsoft.com/default...b;en-us;314546

You can use osql.exe to execute all the commands you need.

Simon

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Craig HB | last post: by
reply views Thread by Mark Johnson | last post: by
2 posts views Thread by Rosy Moss | last post: by
reply views Thread by WoodBeeProgrammer | last post: by
5 posts views Thread by Robert Schuldenfrei | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.