Showing posts with label updates. Show all posts
Showing posts with label updates. Show all posts

Monday, March 19, 2012

Does Log Shipping Handle Schema Changes from Primary to Secondary

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 .

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

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