Share Point Migration (SP 2010 to SP 2013)

Share Point migration 2010 to 2013

I need help for migration in SP. The followings are the high level key components those need to migrate from SP 2010. Any suggestions and approaches for the are appreciable.

1) I have one portal that need to be migrate from SP 2010 to SP 2013: 

    I) How to migrate portal from SP 2010 to 2013 from scratch without using any tools? 

   II) How to deploy visual  web parts to SP 2013. Is their any impact of app model? is it any changes are required to current visual web part like configuration changes etc?

2) In portal we are using SSRS reports and PPS:

    I) How to migrate SSRS reports from SP 2010 to SP 2013?

 

   II) Is all reports will come automatically when we restore content DB to SP 2013?

   III) If no then how to deploy from BID or is there any other options to optimize this work?

3) Also we have one external DB that needs to be migrated from SQL Server 2008 to 2012.

   I) What is the best approach to migrate database from SQL Server 2008 to SQL 2012?

Thanks in advance...  :) 

AutoComplete Extender Example

 <asp:TextBox ID="txtPatName" runat="server" AutoPostBack="True" CssClass="textSearch"
                                    OnTextChanged="txtPatName_TextChanged" Width="300px"></asp:TextBox>
                                <div id="divwidth">
                                </div>
                                <cc1:AutoCompleteExtender ID="txtPatName_AutoCompleteExtender" runat="server" Enabled="True"
                                    MinimumPrefixLength="1" ServiceMethod="GetEmrPatientList" ServicePath="~/Service/EMRWebService.asmx"
                                    TargetControlID="txtPatName" CompletionSetCount="20" CompletionListItemCssClass="AutoExtenderList"
                                    CompletionListCssClass="AutoExtender" CompletionListHighlightedItemCssClass="AutoExtenderHighlight"
                                    CompletionListElementID="divwidth" DelimiterCharacters="">
                                </cc1:AutoCompleteExtender>

//Web Service As
private List<String> List(string key)
    {

        List<String> List = new List<string>();
        DataTable dtEmrPat = new DataTable();
        using (cls obj = new cls())
        {
            if (Session["XYZ"].ToString().Equals(""))
            {
                dt = obj.GetList(key);
            }
            else
            {
                dt = obj.GetAllLists(key);
            }

            if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
            {
                Session["EmrPatients"] = dt;
                foreach (DataRow dr in dt.Rows)
                {
                    stringname = dr["Name"].ToString();
                    List .Add(stringname );
                }
            }
            return List ;
        }
    }

Load Page In IFrame Through JQuery

<script language="javascript" type="text/javascript">
$(document).ready(function(){
 
   $('#A').click(function(){
      ShowPage('A');
   });
  
   $('#A1').click(function(){
      ShowPage('A1');
   });
  
   $('#A2').click(function(){
      ShowPage('A2');   
   });
  
    function ShowPage(PageName)
    {
       if(PageName=='A')
       {
           $('#frame').attr('src','A.aspx');   
           $('#frame').css('height',600);
           $('#lblPageName').text('A');
       }
       else if(PageName=='A1')
       {
           $('#frame').attr('src','A1.aspx');   
           $('#frameEMR').css('height',200);
           $('#lblPageName').text('A1');
       }
       else if(PageName =='A2')
       {
           $('#frame').attr('src','A2.aspx');   
           $('#frame').css('height',100);
           $('#lblPageName').text('A2');
       }
    }
});
</script>

Grid with data key

<asp:GridView ID="gv" runat="server" Width="70%"   AutoGenerateColumns="false"
                    OnSelectedIndexChanged="gv_SelectedIndexChanged" DataKeyNames="Id">
                    <Columns>
                        <asp:CommandField ShowSelectButton="true" ItemStyle-Width="10pt" />
                        <asp:BoundField DataField="Name" HeaderText="Name" />
                    </Columns>
                </asp:GridView>

Call Explicitly Javascript function After Some Server Side Code

Page.ClientScript.RegisterStartupScript(GetType(), "delMsg", "alert('Record Deleted');", true);

ScriptManager.RegisterClientScriptBlock(upSSP, upSSP.GetType(), "BindSWF", "CreateSSPSwf();", true);

Grid View Selected key

<asp:GridView ID="gvExamInGr" runat="server" AutoGenerateColumns="False" EmptyDataText="Record Does Not Exist"
                            DataKeyNames="GrNo" OnSelectedIndexChanged="gvExamInGr_SelectedIndexChanged">


GrNo = Convert.ToInt64(gvExamInGr.SelectedDataKey.Value.ToString());

Toggle the Div in JavaScript

function ToggleContent(dvToggle)
{  
    var contentId = document.getElementById(dvToggle);
    contentId.style.display == "block" ? contentId.style.display = "none" :
    contentId.style.display = "block";
}