Anyone, we have a Vendor application where we install modules or
software that updates our primary production database. We have a
reporting database that is updated via log shipping. I believe that
the article by Paul Ibison log shipping v. replication answers my question
but wanted
to know if I was missing something. So here goes. When we do an
install of a module or software it modifies our primary database. From
Paul is saying in his article it looks like any schema changes in
the primary database would not be done in the reporting database. Is
this correct?
References:
Log Shipping v. Replication
http://www.sqlservercentral.com/columnists/pibison/logshippingvsreplication.asp
Using Secondary Servers for Query Processing
http://msdn2.microsoft.com/en-us/library/ms189572.aspx
Thanks,
Chad
Hi Chad - absolutely. This is one of the differences cf replication - ALL
schema changes are replicated. In SQL Server 2005 you can replicate ddl
changes which makes it closer but not all changes are replicated to the
subscribers.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Showing posts with label updates. Show all posts
Showing posts with label updates. Show all posts
Monday, March 19, 2012
Sunday, March 11, 2012
Does index-rebuilding update statistics?
Hi, everybody!
Recently, I've decided that I should do index-rebuilding.
I wonder doing it updates statistics automatically.
Thanks in advance.> I wonder doing it updates statistics automatically.
Yes, unless you use the STATISTICS_NORECOMPUTE clause in the CREATE INDEX
statements.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
Recently, I've decided that I should do index-rebuilding.
I wonder doing it updates statistics automatically.
Thanks in advance.> I wonder doing it updates statistics automatically.
Yes, unless you use the STATISTICS_NORECOMPUTE clause in the CREATE INDEX
statements.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
Labels:
automatically,
database,
decided,
everybody,
index-rebuilding,
microsoft,
mysql,
oracle,
server,
sql,
statistics,
update,
updates
Friday, February 24, 2012
Does .NET support mySQL connectivity?
If so, what category does this fall under? (ODBC, etc). I need to be able to send queries and updates through C++ .NET 2.0.You can connect to MySQL through ODBC, but there seems to be a more native driver for it, too: http://dev.mysql.com/doc/refman/5.0/en/connector-net.html
Subscribe to:
Posts (Atom)