SEO

#1 (**permalink**) 02-29-2008, 07:07 AM

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

#2 (**permalink**) 02-29-2008, 07:08 AM

"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

#3 (**permalink**) 02-29-2008, 07:08 AM

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" <sql@hayes.ch> wrote in message
news:426559e8$1_3@news.bluewin.ch...
>
> "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
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Using MSDE and moving databases