If both your servers are accessible from the same network that you're connected from then you can use sql import/export wizard

Hi, you can try changing the web.config file from target framework node from pointing to 2.0 to 4.5 and try.

It's always good to check whether a particular record is existing or not before accessing that record. Specially in collections, sometimes it maybe empty or less than the number of required records that you want to access. The following code will execute based on the records available

        DataTable table = new System.Data.DataTable();
        table.Columns.Add("ID");
        table.Rows.Add("1");
        string test = string.Empty;

        int num\_of\_records = table.Rows.Count;
        if (num\_of\_records > 0)
        {
            test = table.Rows\[0\]\[0\].ToString();
        }
        else
        {
            return;
        }

The following code is directly trying to access a record which may or may not be existing though the code is syntactically correct it may throw error in the event of unavailablity of records.

        DataTable table = new System.Data.DataTable();
        table.Columns.Add("ID");            
        string test = string.Empty;
        test = table.Rows\[0\]\[0\].ToString();

IndexOutOfRangeException - There is no row at position 0.