By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,231 Members | 1,707 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,231 IT Pros & Developers. It's quick & easy.

MS SQL 2005 Express Edition - Replication Question

P: n/a
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!
Dec 19 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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!
Dec 20 '07 #2

P: n/a
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/prodinf...-features.mspx

--
Peter Doering [MVP Access]
Dec 20 '07 #3

P: n/a
On Wed, 19 Dec 2007 20:39:45 -0700, Tom van Stiphout
<no*************@cox.netwrote:
>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 !!
Dec 20 '07 #4

P: n/a
On Thu, 20 Dec 2007 10:22:53 +0100, Peter Doering <no****@doering.org>
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/prodinf...-features.mspx

Many Thanks !!
Dec 20 '07 #5

P: n/a
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.
Dec 21 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.