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.

replication on access DB

may I use the replication to sincronize an access database?
if yes, how can I do it?
thanks
Marco,
have a look in BOL for 'Subscribers, heterogeneous'. There are a few pages
relating to the setup with Access. You'll need to enable your publication
for heterogenous subscribers and create a linked server as a datasource, and
enable the new subscriber as the access database.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||download the sample chapter from here. It explains how to do it.
http://www.nwsu.com/0974973602.html
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Melluso" <marcomelluso@.hotmail.com> wrote in message
news:OxVXVUnlFHA.3656@.TK2MSFTNGP09.phx.gbl...
> may I use the replication to sincronize an access database?
> if yes, how can I do it?
> thanks
>

Replication Issue Syntax error or access violation

I am replication on a SQL Server 2000 env on Windows Server 2003. I randomly
get an access violation error stating "Syntax error or access violation" ODBC
error 37000. After further investigation using sp_browsereplcmds I see that
a blank field in the db is sending the following repeated about 30 times.
''+{fn CHAR(0)}+''+{fn CHAR(0)}
I am using sql server generated procs. I also have 4 other publishers using
the same table without an errors. I am looking for a solution rather than a
work around. Any ideas?
Thanks,
TK
This looks like a bug. Can you call PSS on it.
If you are looking for a work around, study the transaction which caused
this sequence of commands. Sometimes if you set columns to "", you can get
some weird occurences. Most of these problems have been patched however.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"TK" <TK@.discussions.microsoft.com> wrote in message
news:7DAEE7FE-2CA7-495B-8E8D-4B65EB40BA30@.microsoft.com...
>I am replication on a SQL Server 2000 env on Windows Server 2003. I
>randomly
> get an access violation error stating "Syntax error or access violation"
> ODBC
> error 37000. After further investigation using sp_browsereplcmds I see
> that
> a blank field in the db is sending the following repeated about 30 times.
> ''+{fn CHAR(0)}+''+{fn CHAR(0)}
> I am using sql server generated procs. I also have 4 other publishers
> using
> the same table without an errors. I am looking for a solution rather than
> a
> work around. Any ideas?
> --
> Thanks,
> TK