Newbie SQL Server Question

I've been experimenting with SQL Server Express and have successfully
upsized a couple of databases i.e. the tables are now on the local
installation of SQL Server on my C drive and they are successfully
linked to the frontend .mde file, also on my C drive.

If I have a database in a location remote to myself that is currently
using Jet and I want to upsize it to SQL Server can it be as simple as
the following or am I oversimplifying things:

1. Get the remote user to send me their data file.

2. Upsize the data file on to my C drive installation of SQL Server
Express and deal with any upsizing issues that may arise.

3. Send the relevant SQL Server files that are located at "C:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" to the remote user
together with a new frontend .mde file (or does this have to be
the .mdb file?).
There seems to be 2 relevant files, one .mdf and one .ldf file on my
local install of SQL Server. Are these the only relevant files?

4. Have the remote user's IT people install the files that I have sent
them on to SQL Server 2005 that they have installed on their server.

5. Have the same IT people set the datasource of the Frontend .mde
(or .mdb?) file that I have sent them.

I will be very thankful for any help that I can get with this.

Re: Newbie SQL Server Question

josephlee@live.com.au wrote in news:c85b809d-9c48-4526-9b14-bc25d00ed828
@i12g2000prf.googlegroups.com:

> I've been experimenting with SQL Server Express and have successfully
> upsized a couple of databases i.e. the tables are now on the local
> installation of SQL Server on my C drive and they are successfully
> linked to the frontend .mde file, also on my C drive.
>
> If I have a database in a location remote to myself that is currently
> using Jet and I want to upsize it to SQL Server can it be as simple as
> the following or am I oversimplifying things:
>
> 1. Get the remote user to send me their data file.
>
> 2. Upsize the data file on to my C drive installation of SQL Server
> Express and deal with any upsizing issues that may arise.
>
> 3. Send the relevant SQL Server files that are located at "C:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" to the remote user
> together with a new frontend .mde file (or does this have to be
> the .mdb file?).
> There seems to be 2 relevant files, one .mdf and one .ldf file on my
> local install of SQL Server. Are these the only relevant files?
>
> 4. Have the remote user's IT people install the files that I have sent
> them on to SQL Server 2005 that they have installed on their server.
>
> 5. Have the same IT people set the datasource of the Frontend .mde
> (or .mdb?) file that I have sent them.
>
> I will be very thankful for any help that I can get with this.

There might be less overhead and fewer opportunities for confusion were
you to create a new, non-additive backup of the database (which will
default to an extension of .bak probably) and to send it to whomever.
These will be one file only with which to deal and, if you set the backup
to a new device (file), say "MyDatabase.bak" in your temp or other
folder, then the file should be relatively small and the integrity of
your database and its regular backup should not be threatened.

The recipients can restore your database from the backup file and this is
quite an easy and straight forward procedure; usually the only
intervention required is to identify the location of the files.

IMO, Microsoft SQL Server Management Studio Express, a free download from
Microsoft, simplifies many tasks which are cumbersome in Access.

Re: Newbie SQL Server Question

On Jan 24, 7:38=A0pm, lyle fairfield wrote:

> There might be less overhead and fewer opportunities for confusion were
> you to create a new, non-additive backup of the database (which will
> default to an extension of .bak probably) and to send it to whomever.
> These will be one file only with which to deal and, if you set the backup
> to a new device (file), say "MyDatabase.bak" in your temp or other
> folder, then the file should be relatively small and the integrity of
> your database and its regular backup should not be threatened.
>
> The recipients can restore your database from the backup file and this is
> quite an easy and straight forward procedure; usually the only
> intervention required is to identify the location of the files.
>
> IMO, Microsoft SQL Server Management Studio Express, a free download from
> Microsoft, simplifies many tasks which are cumbersome in Access.- Hide quo=
ted text -
>
Thanks for the info Lyle. I'll follow your advice and see how I go.
And yes, I do have Management Studio Express installed and it does
make life easier.