Hello,

I am looking for help from anyone who has had to trouble shoot publishing a database with GoDaddy.com.  I am attempting to move a website to GoDaddy hosting.  They will not allow me to recover my database from a .bak file but I must use the SQL Database Publishing tool instead.  When I run scripts are being published to the webservice I get the below error.  Has anyone had to trouble shoot this before and have a solution?

Microsoft.SqlServer.Management.SqlScriptingEngine.PublishingServiceException: An error occurred while trying to publish the following script:IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Users] ---> System.Web.Services.Protocols.SoapException: Could not drop object 'dbo.aspnet_Users' because it is referenced by a FOREIGN KEY constraint. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.Tools.HostingServices.PublishService.PublishScript(String script) at Microsoft.SqlServer.Management.SqlScriptingEngine.PublishToWebWriterProvider.PublishScript(String script) --- End of inner exception stack trace --- at Microsoft.SqlServer.Management.SqlScriptPublish.GeneratePublishPage.worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)