tag:blogger.com,1999:blog-5704450.post7837033456027003924..comments2024-03-20T20:27:05.438-07:00Comments on Vishal Joshi's Tangent: How to transfer your DB using MSDeploy command LineVishal R Joshihttp://www.blogger.com/profile/05217117734084631137noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-5704450.post-86897132315390213832014-06-01T19:04:54.803-07:002014-06-01T19:04:54.803-07:00I worked on my local pc with different databases, ...I worked on my local pc with different databases, but not with the one on GoDaddy hosting.<br />There's a link guided me with the command line:<br />"msdeploy.exe -verb:sync -source:dbDacFx="your GoDaddy connection string" -dest:dbDacFx="your local connection string""<br />But it's been giving me the error:<br />"ERROR_DACFX_NEEDED_FOR_SQL_PROVIDER. The SQL provider cannot run with dacpac option because of a missing dependency. Please make sure that DacFx is installed".<br />So could anyone suggest me a way for transferring database between local and godaddy? ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5704450.post-25723937925240718972010-08-22T23:21:49.858-07:002010-08-22T23:21:49.858-07:00Hi Kiran,
Re: Scripting Data
You can set ...Hi Kiran,<br /> Re: Scripting Data<br /> You can set ScriptData=True as shown above and your data should get scripted too...<br /><br /> Re: Locking of DB<br /> I do not think that the DB should get locked as Web Deploy is just trying to read the DB... If you are using SQL Express then you might face problems as many times SQL MDF files do get locked...<br /><br /> Btw, I recommend you touch base with your DBA, my hope is that this increases your convinience and makes both you and your DBA happy...<br />Thanks<br />VishalVishal R Joshihttps://www.blogger.com/profile/05217117734084631137noreply@blogger.comtag:blogger.com,1999:blog-5704450.post-261660899019906762010-08-22T00:14:07.207-07:002010-08-22T00:14:07.207-07:00Thanks Vishal, this is great, no more have to ask ...Thanks Vishal, this is great, no more have to ask and wait for DBA to give a temporary test environment, does it take snapshot of entire source (tables, indexes, SProcs, Replication publishers etc.,) is there a way to get the data as well and if so what is the performance hit source takes, say a huge source, does running this locks down the source server for long period of time.Anonymoushttps://www.blogger.com/profile/08279061669619384486noreply@blogger.comtag:blogger.com,1999:blog-5704450.post-40068720897638587812009-07-14T23:53:57.815-07:002009-07-14T23:53:57.815-07:00Hi Thomas,
MsDeploy uses SQL Management Object...Hi Thomas,<br /> MsDeploy uses SQL Management Objects (SMO) behind the scenes... Unfortunately it seems like SMO does not support database diagrams at this time... I have informed the SMO team to consider this for the future releases... As soon as the supported release is available MsDeploy will be able to directly consume it...<br />-VishalVishal R Joshihttps://www.blogger.com/profile/05217117734084631137noreply@blogger.comtag:blogger.com,1999:blog-5704450.post-70599640079609323852009-07-12T16:15:16.358-07:002009-07-12T16:15:16.358-07:00This doesn't copy database diagrams, is there ...This doesn't copy database diagrams, is there an option to enable copying database diagrams?Thomas Coatsnoreply@blogger.comtag:blogger.com,1999:blog-5704450.post-87278427567080652522009-05-28T21:48:15.084-07:002009-05-28T21:48:15.084-07:00Hi Kiran,
Can you suggest the steps you are fo...Hi Kiran,<br /> Can you suggest the steps you are following using VS10 for deployment?<br />-VishalVishal R Joshihttps://www.blogger.com/profile/05217117734084631137noreply@blogger.comtag:blogger.com,1999:blog-5704450.post-3231157705660984612009-05-28T21:45:23.096-07:002009-05-28T21:45:23.096-07:00hi i am using xp operating system and i installed ...hi i am using xp operating system and i installed vs2010 when i am using ms deploy tool for database deploy i got this error how to resolve this<br /><br />error:-Cannot connect to pubs database<br /><br />Cannot initialize SSPI packagesKiran Kumarhttps://www.blogger.com/profile/13101083235059990863noreply@blogger.com