Issue happened with MOSS 2007

Problem
We have SharePoint server 2007 connected to the production environment with the SQL Data base name WSS_Content_P. Due to some technical changes we by mistake triggered the Production Front end to the Test environment Database that is WSS_Content_T . Here the Test database was just the replica of the production database with difference of 2 days. Now after some days we got to know that such a problem has been created. We found that business data of 2 days was missing from the database.
Solution : In the End we came to solution to any how sync the two databases. Now we needed the best database comparison tool to check the data from the two database server.
Tool Used:  VISUAL STUDIO
Internal Tool : SQL > DATA COMPARE
·         Click the Data compare option in visual studio.
·         Provide the connection to both the databases, one will be source and other will be the destination.
·         Now we have four different option
o   Different Records: Scans all the records in the database on the basics of primary keys to find the updates and changes.
o   Only in Source: Compares both the databases for the different rows in the source database.
o   Only in Destination: Compare both the databases for the different rows in the destination, after this we can create a script which deletes the extra file from the destination.
o   Identical records: Compare and provides the list of identical fields in the database.
·         After this it shows a comparison summary.
·         This click script button in the tool bar. This will create a query for required data change.
·         Run this query script on the production database. And reconnected the databases. 
In our case we require the data from the source to the destination, where source is the test environment and destination is the production environment.
NOTE: KINDLY TAKE THE BACKUP OF BOTH THE DATABASES TO HAVE DATA SECURITY
What we did to resolve our Problem.
1.       Selecting the Test database as source and destination as production database.
2.       Then selecting the different records and only insource option we move forwarded.
3.       A comparison summary was created which we analyzed before going further to know that we are having the correct data changes. We checked for update queries.
4.       Then we executed the queries on the production environment.

5.       Then we connected the databases back to the frontend and check to get the desired output.

Comments

Post a Comment

Popular posts from this blog

How to use lamda expression for updating using LINQ

This is small example showing how we use lamda expression in the programming section , Generally we use lamda expression when working wiht LINQ , or the classs of list type where need to get the data based on any where clause. public Boolean Update(string id) { int flag = 0; string str = DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year; foreach (var c in obj.Task_Details.Where(x => x.task_no == id)) { c.task_date = str; flag = 1; c.status = "Complete"; } obj.SaveChanges(); if (flag == 1) { return true; } else { return false; } }
Read more

using session for login and logout in asp.net

firstly open the "Global.aspx". then create a function there  protected void Application_Start() { //we give the name of the session  here and declare it null ..username is the name of the session //we can change it according to our needs Sesssion["username"]=""; } now we can create the function where we are login as function boolean login( string username, string password) {   // firstly we match the login details from the database. if(username == logincredintialfromdb && password ==logincredintialfromdb ) { // the values are matched here so are assiging the value to the session variable Session["username"]= username ; return true; } else { return false; } }
Read more

How to post data in MVC using form collection for Beginners.

Here we can simply put the data into the form tag and give each component an name .We are creating a login form using the MVC Architecture. <form method="post" action="Name_of_the_function> <input type="text" name=username id=username> <input type="password" name =pass id=pass> <input id=submit type="submit"> on controller [httppost] public ActionResult Name_of_the_function(formcollection form) { string str=form["username"]; string str1= form["pass"]; }
Read more