MS SQL 2005 Express Edition - Replication Question

Hello...

I'm new to MS SQL, so please be nice... LOLOL

I decided to go from Access 2003 with the MS SQL Express Edition (I
really don't need all the features of the full version, if so, I can
buy it in the future). MS Access as the Frond End and SQL as the Back
End.

Right now is installed on a Windows 2003 Server and ready to go.

So my question is, It's possible to also install SQL Express on my
laptop, create and/or test the databases, when ready transfer the
Databases to the server? Something like replication?

I would love to do all my programing at home, when I'm more relax,
then go to work the next day and "replicate" the changes.

If this is possible, can you guys point me in the right direction? Any
suggestions?

I'll really appreciate any help..

Thanks!

Re: MS SQL 2005 Express Edition - Replication Question

On Wed, 19 Dec 2007 18:19:40 -0500, Fenix Bird wrote:

What I do is to turn on "generate script" (there is a toolbar button
for it) and with each change I save the change script. I give them a
name starting with a sequential number. Then at work I run the scripts
one at a time to update the work database.

-Tom.


>Hello...
>
>I'm new to MS SQL, so please be nice... LOLOL
>
>I decided to go from Access 2003 with the MS SQL Express Edition (I
>really don't need all the features of the full version, if so, I can
>buy it in the future). MS Access as the Frond End and SQL as the Back
>End.
>
>Right now is installed on a Windows 2003 Server and ready to go.
>
>So my question is, It's possible to also install SQL Express on my
>laptop, create and/or test the databases, when ready transfer the
>Databases to the server? Something like replication?
>
>I would love to do all my programing at home, when I'm more relax,
>then go to work the next day and "replicate" the changes.
>
>If this is possible, can you guys point me in the right direction? Any
>suggestions?
>
>I'll really appreciate any help..
>
>Thanks!

Re: MS SQL 2005 Express Edition - Replication Question

Fenix Bird wrote:

> I decided to go from Access 2003 with the MS SQL Express Edition (I
> really don't need all the features of the full version, if so, I can
> buy it in the future). [...] It's possible to also install SQL Express on my
> laptop, create and/or test the databases, when ready transfer the
> Databases to the server? Something like replication?

As Tom describes, transferring the schema is easiest by generating scripts.
However, there is a powerful replication feature in SQL 2005, that you
cannot use with Express on both sides. To publish a subscription you need
at least the Workgroup edition on the server, see
http://www.microsoft.com/sql/prodinfo/features/compare-featu res.mspx

--
Peter Doering [MVP Access]

Re: MS SQL 2005 Express Edition - Replication Question

On Wed, 19 Dec 2007 20:39:45 -0700, Tom van Stiphout
wrote:

>On Wed, 19 Dec 2007 18:19:40 -0500, Fenix Bird wrote:
>
>What I do is to turn on "generate script" (there is a toolbar button
>for it) and with each change I save the change script. I give them a
>name starting with a sequential number. Then at work I run the scripts
>one at a time to update the work database.
>
>-Tom.
>
>
>>Hello...
>>
>>I'm new to MS SQL, so please be nice... LOLOL
>>
>>I decided to go from Access 2003 with the MS SQL Express Edition (I
>>really don't need all the features of the full version, if so, I can
>>buy it in the future). MS Access as the Frond End and SQL as the Back
>>End.
>>
>>Right now is installed on a Windows 2003 Server and ready to go.
>>
>>So my question is, It's possible to also install SQL Express on my
>>laptop, create and/or test the databases, when ready transfer the
>>Databases to the server? Something like replication?
>>
>>I would love to do all my programing at home, when I'm more relax,
>>then go to work the next day and "replicate" the changes.
>>
>>If this is possible, can you guys point me in the right direction? Any
>>suggestions?
>>
>>I'll really appreciate any help..
>>
>>Thanks!

I'll give it a try..

Many, many thanks !!

Re: MS SQL 2005 Express Edition - Replication Question

On Thu, 20 Dec 2007 10:22:53 +0100, Peter Doering
wrote:

>Fenix Bird wrote:
>
>> I decided to go from Access 2003 with the MS SQL Express Edition (I
>> really don't need all the features of the full version, if so, I can
>> buy it in the future). [...] It's possible to also install SQL Express on my
>> laptop, create and/or test the databases, when ready transfer the
>> Databases to the server? Something like replication?
>
>As Tom describes, transferring the schema is easiest by generating scripts.
>However, there is a powerful replication feature in SQL 2005, that you
>cannot use with Express on both sides. To publish a subscription you need
>at least the Workgroup edition on the server, see
>http://www.microsoft.com/sql/prodinfo/features/compare-feat ures.mspx


Many Thanks !!

Re: MS SQL 2005 Express Edition - Replication Question

On Dec 19, 6:19 pm, Fenix Bird wrote:
> Hello...
>
> I'm new to MS SQL, so please be nice... LOLOL
>
> I decided to go from Access 2003 with the MS SQL Express Edition (I
> really don't need all the features of the full version, if so, I can
> buy it in the future). MS Access as the Frond End and SQL as the Back
> End.
>
> Right now is installed on a Windows 2003 Server and ready to go.
>
> So my question is, It's possible to also install SQL Express on my
> laptop, create and/or test the databases, when ready transfer the
> Databases to the server? Something like replication?
>
> I would love to do all my programing at home, when I'm more relax,
> then go to work the next day and "replicate" the changes.
>
> If this is possible, can you guys point me in the right direction? Any
> suggestions?
>
> I'll really appreciate any help..
>
> Thanks!

Yes it's quite possible.

But being lazy I don't. I "rent" an internet-enabled MS-SQL DB. A
Google search should bring up lots. I think one can rent a web site
hosting servce plus an MS-SQL db for about ten bucks a month.
Why?
It's available to me anywhere there's an internet connection. I can,
but I don't have to, use any of the replication procedures available.
And I never get mixed up about which copy I'm using, nor lose work
because I fumbled the update.
Ah yes! What about security. I rent several of these. One I just keep
to absorb attacks. When the gurus here say, "Never, it's not secure" I
say, "Great, attack my attackable DB, leave a table there with your
name in it." But they are all busy, important men or women and they
have't got around to it yet, Well, they've only had a couple of years.