Replication over Dev Server

I got 2 servers running, Dev and Production
The Production one is the one that the users run on and it's working
with a Access adp project
The Dev one is the migration project that evolve and use VB as
interface.
So my test are made on the Dev version but, the way it work now is i
copy my database files and trasnfert it to my dev server, delete my
current database and relink new files and start working again. Im
doing so for a while now and it become pretty long to do with size
increment. So i think it's time to change to automatic process. I've
tried with DTS packages but DTS transform view into table and don't
transfer everything. So Replication seems the best thing. I need to
know if the current thing his possible and if it is, is there good
tutorial for such replication i could use ?
i would like to replicate my Prod server to Dev each morning and i
don't want Dev modification to propagate to Prod. so make a kind of
backup database in other word.
I would say that your current method is possibly the best. You could use
snapshot replication as an alternative, but if you want the whole database
and are already backing it up, it might be simpler to ship the backups and
restore on the DEV server. If you are going across the network and this is
slow, then you could investigate zipping and unzipping before the file
transfer. I have a similar setup, and even though it isn't out of the box, it
works well.
HTH,
Paul Ibison
|||On Apr 24, 4:28 am, Paul Ibison <Paul.Ibi...@.Pygmalion.Com> wrote:
> I would say that your current method is possibly the best. You could use
> snapshot replication as an alternative, but if you want the whole database
> and are already backing it up, it might be simpler to ship the backups and
> restore on the DEV server. If you are going across the network and this is
> slow, then you could investigate zipping and unzipping before the file
> transfer. I have a similar setup, and even though it isn't out of the box, it
> works well.
> HTH,
> Paul Ibison
Ill this this this morning and see how it goes. should be fast under
1gbit lan.
|||On Apr 24, 8:20 am, Franck <the_darkbl...@.hotmail.com> wrote:
> On Apr 24, 4:28 am, Paul Ibison <Paul.Ibi...@.Pygmalion.Com> wrote:
>
> Ill this this this morning and see how it goes. should be fast under
> 1gbit lan.
i manage a vb script that backup with t-sql the Prod server and after
does a little DOS copy command to the Dev server and T-sql again the
Restore, all that take only 35-40 seconds. restore being the longest
step.