SQL Server to Azure Migration stops on Error Deploy72002


i attempting migrate sql server db azure , have come across few errors 1 have been unable solve. can lend hand.

i using "deploy database sql azure" in ssms.  working fine, db created, tables created , data being migrated until gets table , stops error states:

error deploy72002: bacpac table header not match. '[dbo].[usertitle]' not match '[dbo].[usertitle/adminaccess]'

thanks in advance assistance!

hi voyagr12,

according description, want migrate on premise sql server database azure sql database. make test using deploy database sql azure wizard, works expected , migrate database successfully. please make sure have performed  the following steps.

1. create sql database server  with login , password in windows azure management portal.
2. open sql server management studio (ssms) , connect on premise server. right click database want move, click tasks, deploy database sql azure.
3. click next @ introduction window until @ deployment settings screen. on deployment settings screen click connect connect sql azure server created in step 1.
4. make sure adjust maximum database size desired amount , click next.
5. view summary page , click finish.

please note each table being exported has have clustered index , cannot contain extended properties, more details, please review blog.

besides, recommend use other methods move on premise database azure sql database, such using export/import data-tier application, generate , publish scripts wizard , on, check if successful. more options described in article: migrating databases azure sql database.

sql azure issues, can post question in azure sql database forum @ https://social.msdn.microsoft.com/forums/azure/en-us/home?forum=ssdsgetstarted. appropriate , more experts assist you.


thanks,
lydia zhang

lydia zhang
technet community support




SQL Server  >  SQL Server Migration



Comments

Post a Comment

Popular posts from this blog

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

How to calculate the delta size while diffing the files in TeamFoundationServer ?

currently, need calculate delta size while diffing files in teamfoundationserver, don't know wheter there are existed tfs api in msdn. far did not find it. familiar it? or deliver suggestions? thanks in advance !! thanks materials !! here solution below: private int calsinglefiledelta(string strbase, string strshelve) { int nfiledelta = 0; arraylist alorgstart = new arraylist(); arraylist aldesstart = new arraylist(); arraylist alunchangedlen = new arraylist(); diffsegment diffseg = difference.difffiles(strbase, encoding.ascii.codepage, strshelve, encoding.ascii.codepage, new diffoptions()); if (diffseg != null) { alorgstart.add(diffseg.originalstart); aldesstart.add(diffseg.modifiedstart); alunchangedlen.add(diffseg.modifiedlength); while (diffseg.next != null) { diffseg = diffseg.next; alorgstart.add(diffseg.originalstart); ...
Read more

How to capture screen in silverlight apps

hi  i have searched around web trying find how take screenshot in silerlight applications. can find 1 saying silverlight not support screen capture can not find solution of how solve it.  are there out there know how capture screen in silverlight?  i have found 1 in other forum using web services via rendertargetbitmap stuff: http://social.msdn.microsoft.com/forums/en-us/wpf/thread/08d6b83b-e32a-4f31-9cfe-86b57cb23d42/  . have error saying calling thread must sta..... maybe i'm missing something, image needs accessible server , may not case if use localhost. another problem may image takes litlle while load. try file on server http://www.yourhost.com , give little time load before converting jpeg starting thread , converting after sleep.   tom   Silverlight  >  ...
Read more