"Phil" <Phil@nospam.com> wrote in message
news:d43h6o$829$1@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