Re: MS SQL 2005 Express Edition - Replication Question

On Wed, 19 Dec 2007 20:39:45 -0700, Tom van Stiphout
<no.spam.tom7744@xxxxxxx> 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 !!
.