Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Database replication of just the Schema

  
   Database Help (Home) -> Replication RSS
Next:  BETWEEN vs IN()  
Author Message
gv

External


Since: Sep 13, 2006
Posts: 82



(Msg. 1) Posted: Wed Oct 08, 2008 11:44 am
Post subject: Database replication of just the Schema
Archived from groups: microsoft>public>sqlserver>replication (more info?)
Hi all,

Using SQL 20000 standard Edition SP4

I'm new to replication.
I want to replicate just the schema of a database with no data to another
database and to keep changes in sync all the time.

Can I do this using replication? What kind of subscription?

thanks
gv

 >> Stay informed about: Database replication of just the Schema 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 08, 2008
Posts: 2



(Msg. 2) Posted: Wed Oct 08, 2008 6:26 pm
Post subject: Re: Database replication of just the Schema [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Why not use another tool for this - something like SQLCompare?
It would seem to be more suitable.
HTH,
Paul Ibison (www.replicationanswers.com)

 >> Stay informed about: Database replication of just the Schema 
Back to top
Login to vote
gv

External


Since: Sep 13, 2006
Posts: 82



(Msg. 3) Posted: Fri Oct 10, 2008 10:15 am
Post subject: Re: Database replication of just the Schema [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
company willn't spend any money on even a tool that cost few hundred
dollars.
Out of my control.

Thanks
gv


"Paul Ibison" <Paul.Ibison.DeleteThis@ReplicationAnswers.Com> wrote in message
news:F2ECC392-F354-403D-94B3-5DC79F2D1190@microsoft.com...
> Why not use another tool for this - something like SQLCompare? It would
> seem to be more suitable.
> HTH,
> Paul Ibison (www.replicationanswers.com)
 >> Stay informed about: Database replication of just the Schema 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 91



(Msg. 4) Posted: Fri Oct 10, 2008 10:15 am
Post subject: Re: Database replication of just the Schema [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
OK. Once you're on SQL 2005 and you are using SQL2005 (distributor), there is
an unofficial /NoBcpData switch supported by the snapshot agent that will
help you out.
For the case of SQL 2000 you could create filters on each article to make
sure no data is transferred. This will pick up changed data. It won't pick up
new objects though.
HTH,
Paul Ibison (www.replicationanswers.com)
 >> Stay informed about: Database replication of just the Schema 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Schema changes screw up transactional replication - Hi We have two servers with SQL Server 2005, version 9.0.3042 on both. There is a transactional replication between them but when we make schema changes on the publisher something goes wrong. We get this error message Subquery returned more than 1..

Missing owner specification in replication of schema changes - I have a problem with replicatin schema changes via ALTER TRIGGER. Wondering why they are transferred correctly, but not executed I found the problem in the exists clause which preceeds the statement. Here is the excerpt from the sysmergeschemachange of...

CLR Objects - impossible to remove schema replication from.. - Hi, I've got a database that _was_ replicated at one point. The replication has been removed, and doesn't exist any more. BUT - there appears to be some replication artefacts hanging around for 4 objects. Key info: - 4 objects in sys.objects have....

How much does Replication use tempdb database? - Does Replication create temporary objects in tempdb that take up much space other than monitoring log info? Could such replication objects cause high IO on drive where tempdb resides? A developer was telling me that tempdb is being used by replication...

Cross Database Replication - Is it possible to setup a table in one database to replicate to table in another database on the same machine?
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]