i've got to move 37 SQL Server databases over to new server. My manager tells me that i have to conduct some "check totals" to make sure that the databases contained exactly the same data from what it was when it got moved.
Is there some stored_procedure to do this ? to make sure that all the stored procedures, views, tables got move across ????? Are you kidding me. You detach the databases, then attach them on the new server. There's nowhere for the little data bytes to run and hide. Buy your manager a SQL Server book. :)|||How about sanity testing procedures ?
Write Count scripts to total database records. Is there literature on these kind of topics in SQL Server ?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment