RSS

All Project Updates

Discussions

Issue Tracker

Releases

Reviews

Source Code

Wiki & Documentation

RSS

Discussions List | Create New Discussion

Wiki Link: [discussion:11014]

Cannot Create SQL Script From Database

Tags: Database Publishing Wizard, Hoster Discussion, Using SQL Server in Hosted Environments

trueknight2007

Jun 5 2007 at 5:50 AM

Has anyone else had this error/warning: "There are no objects in database 'C:\Documents and Settings\HPAdministrator.GIDEON\My Documents\Visual Studio 2005\WebSites\test-personal\AppData\CovalenceSQLDatabase.mdf' of the types scriptable by this wizard". If so what causes it and how can I fix it or find a work around? The database I am trying to create the sql file for is for a AJAX enabled website. Any suggestions?

hfrmobile

Jun 12 2007 at 4:10 PM

- try another location of the .mdf file (e.g. C:\Databases\CovalenceSQLDatabase.mdf)
- check if the Wizard has NTFS rights on the .mdf file
- check if the rights in the database are correctly configured

Hvasishth

Coordinator

Jun 18 2007 at 8:08 PM

Edited Jun 18 2007 at 8:12 PM

Can you let me know what type of objects do you have in your database? The Database Publishing Wizard gives this error when none of the objects in the database are supported by it.

The object types which are supported by the Wizard are listed on http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=DPW%20Support%20Matrix&referringTitle=Database%20Publishing%20Wizard.

Thanks
Himanshu

MJKaz

Mar 3 2008 at 9:42 PM

trueknight2007 wrote:
Has anyone else had this error/warning: "There are no objects in database 'C:\Documents and Settings\HPAdministrator.GIDEON\My Documents\Visual Studio 2005\WebSites\test-personal\AppData\CovalenceSQLDatabase.mdf' of the types scriptable by this wizard". If so what causes it and how can I fix it or find a work around? The database I am trying to create the sql file for is for a AJAX enabled website. Any suggestions?

I had this problem. I noticed my path was 131 characters long (just over one of those "powers of two" magic numbers (128 in this case)) and copied the mdf file to a shorter path, ran C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.2\SqlPubWiz.exe independent of Visual Studio, and was quite successful with it. My guess is that it only allows for a 128 character path in all.

SQL Server Hosting Toolkit