Using MSDE and moving databases

[Phil]

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

[Simon Hayes]

"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

[Phil]

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