SQL Migration to Azure Cloud

%3CLINGO-SUB%20id%3D%22lingo-sub-1190970%22%20slang%3D%22en-US%22%3ESQL%20Migration%20to%20Azure%20Cloud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1190970%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EI%20have%20implemented%20a%20basic%20C%23%20application%20connected%20with%20On%20premises%20SQL%20Server%2C%20I%20am%20going%20to%20migrate%20the%20same%20database%20and%20the%20data%20to%20Azure%20cloud%20using%20Microsoft%20Migration%20Tool%2C%20After%20the%20migration%20without%20touching%20the%20coding%20part%20I%20am%20debugging%20the%20same%20application%20(Changed%20the%20connections%20string%20only).%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EOn%20premises%20sql%20database%20connected%20with%20SQL%20Server%2C%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mg%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_19-1582556429018.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173014i5332056774770CC3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_19-1582556429018.png%22%20alt%3D%22Gohulan_19-1582556429018.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_20-1582556429081.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173016i26EC61DA320C4CF8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_20-1582556429081.png%22%20alt%3D%22Gohulan_20-1582556429081.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EIn%20the%20database%20I%20am%20running%20this%20query%20through%20management%20studio%20and%20I%20am%20getting%20the%20following%20results%2C%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mh%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_21-1582556429052.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173015iCABA9260A61C4C54%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_21-1582556429052.png%22%20alt%3D%22Gohulan_21-1582556429052.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_22-1582556429082.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173019iB509240410AB6CED%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_22-1582556429082.png%22%20alt%3D%22Gohulan_22-1582556429082.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ESame%20query%20I%20am%20deploying%20through%20my%20developed%20C%23%20application%2C%20I%20am%20testing%20the%20connection%20with%20sql%20authentication%20credentials%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20mi%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mj%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_23-1582556429053.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173017i9D9A75883C773B01%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_23-1582556429053.png%22%20alt%3D%22Gohulan_23-1582556429053.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_24-1582556429053.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173018iF66616C48BBE6004%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_24-1582556429053.png%22%20alt%3D%22Gohulan_24-1582556429053.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EString%20source%20%3D%20%40%E2%80%9DData%20Source%20%3D%E2%80%9D%20%2B%20textBox1.Text%3B%20Initial%20Catalog%20%3D%20CheckPostingDb%3B%20User%20Id%20%3D%E2%80%9D%20%2B%20textBox2.Text%3B%3B%20Password%3D%E2%80%9D%20%2B%20textBox3.Text%3B%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ESqlConnection%20con%20%3D%20new%20SqlConnection(source)%3B%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3Econ.Open()%3B%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EMessageBox.Show(%E2%80%9CDb%20Connected%E2%80%9D)%3B%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EOnce%20it%E2%80%99s%20succeeded%2C%20I%E2%80%99m%20running%20the%20same%20query%20through%20sqlcommand%20function%20in%20C%23%2C%20got%20the%20same%20results%20in%20the%20text%20box%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20mk%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22ml%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_25-1582556429055.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173020i1B10DD2B1546F679%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_25-1582556429055.png%22%20alt%3D%22Gohulan_25-1582556429055.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_26-1582556429056.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173022i70BD8DCC981D12C8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_26-1582556429056.png%22%20alt%3D%22Gohulan_26-1582556429056.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EString%20sqlSelectQuery%20%3D%20%E2%80%9CSELECT%20COUNT(*)%20AS%20MREQUESTS%20FROM%20MREQUESTS%20WHERE%20REQSTATE%3D1%E2%80%9D%3B%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ESqlCommand%20cmd%20%3D%20new%20SqlCommand(sqlSelectQuery%2C%20con)%3B%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3Eif%20(dr.Read())%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%7B%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EtextBox4.Text%20%3D%20Convert.ToString(dr%5B%E2%80%9CMREQUESTS%E2%80%9D%5D)%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%7D%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3Econ.Close()%3B%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ELet%E2%80%99s%20migrate%20to%20Cloud%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EI%20have%20deployed%20a%20sample%20database%20in%20the%20Azure%20Cloud%20with%20SQL%20authentication%2C%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mm%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_27-1582556429057.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173021i9DFCE3FC029D36BD%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_27-1582556429057.png%22%20alt%3D%22Gohulan_27-1582556429057.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_28-1582556429084.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173024iF0F3265CD77287CB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_28-1582556429084.png%22%20alt%3D%22Gohulan_28-1582556429084.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EIt%E2%80%99s%20just%20a%20blank%20database%20and%20it%20doesn%E2%80%99t%20have%20any%20tables%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mn%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_29-1582556429058.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173023iB8A29DFB590CDB4A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_29-1582556429058.png%22%20alt%3D%22Gohulan_29-1582556429058.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_30-1582556429085.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173025i19CB07D53D64262F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_30-1582556429085.png%22%20alt%3D%22Gohulan_30-1582556429085.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ETried%20the%20same%20query%20here%20and%20returning%20with%20failed%20errors%2C%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mo%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_31-1582556429059.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173026i1CE37478BBB53EEB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_31-1582556429059.png%22%20alt%3D%22Gohulan_31-1582556429059.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_32-1582556429060.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173028i1B4BFDBA772F16A9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_32-1582556429060.png%22%20alt%3D%22Gohulan_32-1582556429060.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EStart%20ab%20new%20project%20type%20as%20Migration%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mp%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_33-1582556429061.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173027iA7DFA8FACFD762FB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_33-1582556429061.png%22%20alt%3D%22Gohulan_33-1582556429061.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_34-1582556429062.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173031iA5F6492935E58355%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_34-1582556429062.png%22%20alt%3D%22Gohulan_34-1582556429062.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EIn%20this%20step%20I%20am%20specifying%20the%20source%20and%20target%20server%20details%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EIn%20my%20scenario%20Source%20server%20is%20in%20localhost%20and%20target%20sql%20server%20is%20in%20Azure%20could%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ESource%20Server%20%E2%80%94%20localhost%20%2C%20Target%20Server%20%E2%80%94%20gohulan.database.windows.net%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mq%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_35-1582556429063.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173029i995435600C0F8A57%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_35-1582556429063.png%22%20alt%3D%22Gohulan_35-1582556429063.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_36-1582556429086.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173030iA0F3F2579897C74C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_36-1582556429086.png%22%20alt%3D%22Gohulan_36-1582556429086.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ESelect%20the%20Correct%20database%20from%20the%20source%20server%20to%20Migrate%20to%20cloud%2C%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mr%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_37-1582556429063.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173032iD1742FE1B59530BD%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_37-1582556429063.png%22%20alt%3D%22Gohulan_37-1582556429063.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_38-1582556429088.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173034iEF9EA723903AF4E6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_38-1582556429088.png%22%20alt%3D%22Gohulan_38-1582556429088.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EIn%20the%20target%20server%20select%20the%20correct%20database%20from%20Azure%20cloud%2C%20in%20my%20Azure%20cloud%20I%20have%20only%20one%20database%20named%20CheckPostingDb%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22ms%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_39-1582556429065.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173033i9F9CED0827BC60C2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_39-1582556429065.png%22%20alt%3D%22Gohulan_39-1582556429065.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_40-1582556429090.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173036i120A27B507AA0C79%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_40-1582556429090.png%22%20alt%3D%22Gohulan_40-1582556429090.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EOnce%20its%E2%80%99s%20connected%20I%20am%20going%20to%20select%20the%20objects%20or%20tables%20from%20the%20source%20database%20that%20I%20would%20like%20to%20migrate%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EIn%20my%20testing%20environment%20I%20am%20selecting%20only%20one%20table%2C%20my%20table%20is%20MREQUESTS%20since%20I%20am%20targeting%20the%20results%20only%20from%20this%20table%20through%20my%20C%23%20application.%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EOnce%20the%20table%20is%20ticked%2C%20I%20have%20generated%20the%20SQL%20script%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mt%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_41-1582556429065.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173035i52D9F9F6F0E23224%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_41-1582556429065.png%22%20alt%3D%22Gohulan_41-1582556429065.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_42-1582556429092.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173037iD68D05DC6B7F4A2A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_42-1582556429092.png%22%20alt%3D%22Gohulan_42-1582556429092.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EOnce%20the%20script%20is%20generated%2C%20I%20am%20deploying%20the%20schema%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%2F********%20DMA%20Schema%20Migration%20Deployment%20Script%20Script%20Date%3A%202%2F24%2F2020%2012%3A50%3A55%20PM%20********%2F%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%2F******%20Object%3A%20Table%20%5Bdbo%5D.%5BMREQUESTS%5D%20Script%20Date%3A%202%2F24%2F2020%2012%3A50%3A55%20PM%20******%2F%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ESET%20ANSI_NULLS%20ON%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EGO%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ESET%20QUOTED_IDENTIFIER%20ON%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EGO%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EIF%20NOT%20EXISTS%20(SELECT%20*%20FROM%20sys.objects%20WHERE%20object_id%20%3D%20OBJECT_ID(N%E2%80%99%5Bdbo%5D.%5BMREQUESTS%5D%E2%80%99)%20AND%20type%20in%20(N%E2%80%99U%E2%80%99))%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EBEGIN%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ECREATE%20TABLE%20%5Bdbo%5D.%5BMREQUESTS%5D(%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BID%5D%20%5Bbigint%5D%20IDENTITY(1%2C1)%20NOT%20NULL%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BRID%5D%20%5Buniqueidentifier%5D%20NOT%20NULL%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BReqTime%5D%20%5Bdatetime%5D%20NOT%20NULL%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BReqState%5D%20%5Btinyint%5D%20NOT%20NULL%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BRecordType%5D%20%5Bint%5D%20NOT%20NULL%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BData1%5D%20%5Bbigint%5D%20NULL%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BServiceID%5D%20%5Bint%5D%20NULL%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BFirstRequestTime%5D%20%5Bdatetime%5D%20NULL%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BOfflinePosting%5D%20%5Bbit%5D%20NULL%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BServiceHostInfo%5D%20%5Bnvarchar%5D(80)%20COLLATE%20SQL_Latin1_General_CP1_CI_AS%20NULL%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ECONSTRAINT%20%5BPK_MREQUESTS%5D%20PRIMARY%20KEY%20CLUSTERED%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E(%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BID%5D%20ASC%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E)WITH%20(PAD_INDEX%20%3D%20OFF%2C%20STATISTICS_NORECOMPUTE%20%3D%20OFF%2C%20IGNORE_DUP_KEY%20%3D%20OFF%2C%20ALLOW_ROW_LOCKS%20%3D%20ON%2C%20ALLOW_PAGE_LOCKS%20%3D%20ON)%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E)%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EEND%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EGO%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EIF%20NOT%20EXISTS%20(SELECT%20*%20FROM%20sys.indexes%20WHERE%20object_id%20%3D%20OBJECT_ID(N%E2%80%99%5Bdbo%5D.%5BMREQUESTS%5D%E2%80%99)%20AND%20name%20%3D%20N%E2%80%99AK_MREQUESTS_RID%E2%80%99)%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ECREATE%20UNIQUE%20NONCLUSTERED%20INDEX%20%5BAK_MREQUESTS_RID%5D%20ON%20%5Bdbo%5D.%5BMREQUESTS%5D%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E(%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BRID%5D%20ASC%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E)WITH%20(PAD_INDEX%20%3D%20OFF%2C%20STATISTICS_NORECOMPUTE%20%3D%20OFF%2C%20SORT_IN_TEMPDB%20%3D%20OFF%2C%20IGNORE_DUP_KEY%20%3D%20OFF%2C%20DROP_EXISTING%20%3D%20OFF%2C%20ONLINE%20%3D%20OFF%2C%20ALLOW_ROW_LOCKS%20%3D%20ON%2C%20ALLOW_PAGE_LOCKS%20%3D%20ON)%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EGO%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EIF%20NOT%20EXISTS%20(SELECT%20*%20FROM%20sys.indexes%20WHERE%20object_id%20%3D%20OBJECT_ID(N%E2%80%99%5Bdbo%5D.%5BMREQUESTS%5D%E2%80%99)%20AND%20name%20%3D%20N%E2%80%99IX_MREQUESTS_2')%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ECREATE%20NONCLUSTERED%20INDEX%20%5BIX_MREQUESTS_2%5D%20ON%20%5Bdbo%5D.%5BMREQUESTS%5D%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E(%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BReqTime%5D%20ASC%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E%5BReqState%5D%20ASC%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3E)WITH%20(PAD_INDEX%20%3D%20OFF%2C%20STATISTICS_NORECOMPUTE%20%3D%20OFF%2C%20SORT_IN_TEMPDB%20%3D%20OFF%2C%20DROP_EXISTING%20%3D%20OFF%2C%20ONLINE%20%3D%20OFF%2C%20ALLOW_ROW_LOCKS%20%3D%20ON%2C%20ALLOW_PAGE_LOCKS%20%3D%20ON)%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EGO%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EAfter%20I%20deployed%20the%20generated%20script%20in%20the%20previous%20step%2C%20it%20doesn%E2%80%99t%20give%20any%20errors%20or%20warnings.%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ESuccessfully%20Executed.%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EOnce%20the%20script%20is%20migrated%2C%20I%20can%20see%20my%20table%20was%20created%20in%20the%20Azure%20cloud.%20But%20my%20query%20was%20returning%20with%200%20results%2C%20it%20means%20that%20MREQUESTS%20table%20has%20been%20deployed%20but%20not%20the%20data%20yet.%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mu%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_43-1582556429066.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173038i8FDD805C5C11939B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_43-1582556429066.png%22%20alt%3D%22Gohulan_43-1582556429066.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_44-1582556429094.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173040iC23D4BC29C921C24%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_44-1582556429094.png%22%20alt%3D%22Gohulan_44-1582556429094.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EI%20am%20migrating%20the%20data%20as%20well%20in%20my%20next%20step%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mv%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_45-1582556429067.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173039i45E2601485424954%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_45-1582556429067.png%22%20alt%3D%22Gohulan_45-1582556429067.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_46-1582556429095.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173042i13B213484A9C1973%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_46-1582556429095.png%22%20alt%3D%22Gohulan_46-1582556429095.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EOnce%20after%20I%20started%20the%20migration%20it%20will%20start%20the%20process%20to%20send%20the%20data%20to%20cloud%2C%20time%20depends%20on%20the%20data%20capacity%20and%20the%20network%20speed.%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mw%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_47-1582556429068.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173041i8B1FFF84BF02FA43%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_47-1582556429068.png%22%20alt%3D%22Gohulan_47-1582556429068.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_48-1582556429068.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173043i34E4A51ED76B8201%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_48-1582556429068.png%22%20alt%3D%22Gohulan_48-1582556429068.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ESince%20my%20table%20doesn%E2%80%99t%20have%20huge%20data%20it%20finished%20with%20in%20short%20time%20without%20any%20warning%20or%20errors.%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22mx%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_49-1582556429070.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173044i43BD9574D6433872%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_49-1582556429070.png%22%20alt%3D%22Gohulan_49-1582556429070.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_50-1582556429097.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173046i98E2568F833870F7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_50-1582556429097.png%22%20alt%3D%22Gohulan_50-1582556429097.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3ERunning%20the%20same%20query%20in%20the%20Query%20Editor%20in%20Azure%20to%20check%20my%20data%2C%20it%E2%80%99s%20succeeded%20and%20returned%20with%20same%20value%20as%20on-premise%20query%20returns%20earlier.%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20lx%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22my%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_51-1582556429070.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173045iBA992CF27568836E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_51-1582556429070.png%22%20alt%3D%22Gohulan_51-1582556429070.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_52-1582556429071.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173048i392F9D703720114E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_52-1582556429071.png%22%20alt%3D%22Gohulan_52-1582556429071.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EReturning%20to%20my%20C%23%20application%20and%20no%20changes%20made%20in%20the%20application%20but%20changing%20the%20connection%20string%20by%20changing%20the%20server%20name%20and%20sql%20authentication%20credentials%2C%3C%2FP%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EDebugging%20the%20application%20to%20confirm%20it%E2%80%99s%20functioning%20properly%2C%20tested%20my%20connection%20with%20correct%20sql%20credentials%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20mz%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22na%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_53-1582556429072.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173047i7292D8F36E310DD9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_53-1582556429072.png%22%20alt%3D%22Gohulan_53-1582556429072.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_54-1582556429073.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173049i85417A3A6AF3D3BC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_54-1582556429073.png%22%20alt%3D%22Gohulan_54-1582556429073.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22hc%20hd%20ct%20ax%20he%20b%20hf%20lp%20hh%20lq%20lr%20ls%20lt%20lu%20lv%20lw%20hp%20gf%22%3EWow%20the%20results%20as%20expected%2C%20means%20Migration%20is%20succeeded.%3C%2FP%3E%3CDIV%20class%3D%22md%20me%20br%20mf%20v%22%3E%3CDIV%20class%3D%22t%20u%20nb%22%3E%3CDIV%20class%3D%22gq%20y%20br%20gr%22%3E%3CDIV%20class%3D%22nc%20y%22%3E%3CDIV%20class%3D%22bq%20gn%20z%20ab%20ac%20fq%20v%20bj%20go%20gp%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_55-1582556429074.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173050i050EA403DDAA59F8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_55-1582556429074.png%22%20alt%3D%22Gohulan_55-1582556429074.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gohulan_56-1582556429075.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173051i3790CD95333C3F73%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Gohulan_56-1582556429075.png%22%20alt%3D%22Gohulan_56-1582556429075.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1190970%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edatabase%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDiscovery%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMigration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOn%20Premises%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

I have implemented a basic C# application connected with On premises SQL Server, I am going to migrate the same database and the data to Azure cloud using Microsoft Migration Tool, After the migration without touching the coding part I am debugging the same application (Changed the connections string only).

On premises sql database connected with SQL Server,

Gohulan_19-1582556429018.png

 

Gohulan_20-1582556429081.png

 

In the database I am running this query through management studio and I am getting the following results,

Gohulan_21-1582556429052.png

 

Gohulan_22-1582556429082.png

 

Same query I am deploying through my developed C# application, I am testing the connection with sql authentication credentials

Gohulan_23-1582556429053.png

 

Gohulan_24-1582556429053.png

 

String source = @”Data Source =” + textBox1.Text; Initial Catalog = CheckPostingDb; User Id =” + textBox2.Text;; Password=” + textBox3.Text;

SqlConnection con = new SqlConnection(source);

con.Open();

MessageBox.Show(“Db Connected”);

Once it’s succeeded, I’m running the same query through sqlcommand function in C#, got the same results in the text box

Gohulan_25-1582556429055.png

 

Gohulan_26-1582556429056.png

 

String sqlSelectQuery = “SELECT COUNT(*) AS MREQUESTS FROM MREQUESTS WHERE REQSTATE=1”;

SqlCommand cmd = new SqlCommand(sqlSelectQuery, con);

if (dr.Read())

{

textBox4.Text = Convert.ToString(dr[“MREQUESTS”])

}

con.Close();

Let’s migrate to Cloud

I have deployed a sample database in the Azure Cloud with SQL authentication,

Gohulan_27-1582556429057.png

 

Gohulan_28-1582556429084.png

 

It’s just a blank database and it doesn’t have any tables

Gohulan_29-1582556429058.png

 

Gohulan_30-1582556429085.png

 

Tried the same query here and returning with failed errors,

Gohulan_31-1582556429059.png

 

Gohulan_32-1582556429060.png

 

Start ab new project type as Migration

Gohulan_33-1582556429061.png

 

Gohulan_34-1582556429062.png

 

In this step I am specifying the source and target server details

In my scenario Source server is in localhost and target sql server is in Azure could

Source Server — localhost , Target Server — gohulan.database.windows.net

Gohulan_35-1582556429063.png

 

Gohulan_36-1582556429086.png

 

Select the Correct database from the source server to Migrate to cloud,

Gohulan_37-1582556429063.png

 

Gohulan_38-1582556429088.png

 

In the target server select the correct database from Azure cloud, in my Azure cloud I have only one database named CheckPostingDb

Gohulan_39-1582556429065.png

 

Gohulan_40-1582556429090.png

 

Once its’s connected I am going to select the objects or tables from the source database that I would like to migrate

In my testing environment I am selecting only one table, my table is MREQUESTS since I am targeting the results only from this table through my C# application.

Once the table is ticked, I have generated the SQL script

Gohulan_41-1582556429065.png

 

Gohulan_42-1582556429092.png

 

Once the script is generated, I am deploying the schema,

/******** DMA Schema Migration Deployment Script Script Date: 2/24/2020 12:50:55 PM ********/

/****** Object: Table [dbo].[MREQUESTS] Script Date: 2/24/2020 12:50:55 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[MREQUESTS]’) AND type in (N’U’))

BEGIN

CREATE TABLE [dbo].[MREQUESTS](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[RID] [uniqueidentifier] NOT NULL,

[ReqTime] [datetime] NOT NULL,

[ReqState] [tinyint] NOT NULL,

[RecordType] [int] NOT NULL,

[Data1] [bigint] NULL,

[ServiceID] [int] NULL,

[FirstRequestTime] [datetime] NULL,

[OfflinePosting] [bit] NULL,

[ServiceHostInfo] [nvarchar](80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

CONSTRAINT [PK_MREQUESTS] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

)

END

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N’[dbo].[MREQUESTS]’) AND name = N’AK_MREQUESTS_RID’)

CREATE UNIQUE NONCLUSTERED INDEX [AK_MREQUESTS_RID] ON [dbo].[MREQUESTS]

(

[RID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE ​= OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N’[dbo].[MREQUESTS]’) AND name = N’IX_MREQUESTS_2')

CREATE NONCLUSTERED INDEX [IX_MREQUESTS_2] ON [dbo].[MREQUESTS]

(

[ReqTime] ASC,

[ReqState] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE ​= OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

GO

After I deployed the generated script in the previous step, it doesn’t give any errors or warnings.

Successfully Executed.

Once the script is migrated, I can see my table was created in the Azure cloud. But my query was returning with 0 results, it means that MREQUESTS table has been deployed but not the data yet.

Gohulan_43-1582556429066.png

 

Gohulan_44-1582556429094.png

 

I am migrating the data as well in my next step

Gohulan_45-1582556429067.png

 

Gohulan_46-1582556429095.png

 

Once after I started the migration it will start the process to send the data to cloud, time depends on the data capacity and the network speed.

Gohulan_47-1582556429068.png

 

Gohulan_48-1582556429068.png

 

Since my table doesn’t have huge data it finished with in short time without any warning or errors.

Gohulan_49-1582556429070.png

 

Gohulan_50-1582556429097.png

 

Running the same query in the Query Editor in Azure to check my data, it’s succeeded and returned with same value as on-premise query returns earlier.

Gohulan_51-1582556429070.png

 

Gohulan_52-1582556429071.png

 

Returning to my C# application and no changes made in the application but changing the connection string by changing the server name and sql authentication credentials,

Debugging the application to confirm it’s functioning properly, tested my connection with correct sql credentials

Gohulan_53-1582556429072.png

 

Gohulan_54-1582556429073.png

 

Wow the results as expected, means Migration is succeeded.

Gohulan_55-1582556429074.png

 

Gohulan_56-1582556429075.png

 

0 Replies