Stack Overflow
Stack Overflow

Questions tagged [databasepublishingwizard]

7 questions
14
votes
2 answers

How do I fix "incorrect syntax near GO" errors in scripts generated with Microsoft's Database Publishing Wizard?

I've been searching for a "definitive" solution to this for a couple of hours now and can't find out exactly what the problem is so am hoping someone can point me in the right direction. I'm trying to create a script for a database (an MDF file DB)…
Kevin Wilson
  • 7,753
  • 8
  • 35
  • 39
3
votes
2 answers

SQL server version 10 is not supported Error

Does anybody know where I can find the SQL Database Publishing Wizard for SQL Server 2008? When I try and run version 1.1 it says that SQL server version 10 is not supported. I found a MSDN article that states there is a SQL Database publishing…
Adam
  • 306
  • 2
  • 9
1
vote
1 answer

How to use Sql Server Database Publishing Wizard to make a schema with NO DATA?

I can't seem to figure out how to get it to create a script that does not also include all the data, for creating an empty shell of the database. Or will I have to manually remove all the INSERTS?
MetaGuru
  • 42,847
  • 67
  • 188
  • 294
1
vote
1 answer

How to access SQL Server Publishing Wizard 1.4

I've had a big problem in replicating a simple SQL Server 2008 R2 Express database for use on a development server. I thought I had it sorted but it turns out that each table has lost it's 'Identity' value somewhere along the line, and it's not…
Dan
  • 5,836
  • 22
  • 86
  • 140
1
vote
2 answers

Unable to connect to remote SQL Server 2005

I have created my asp.net website using database ASPNETDB.MDF but when I try to host my site on server ... The SQL Server 2005 hosting provider issue me the database name dobriyalji server ip : 69.112.222.220 database username : XXXX database…
ClixNCash
  • 81
  • 1
  • 4
  • 14
1
vote
1 answer

How do you export settings from the Database Publishing Wizard?

I'm using the Database Publishing Wizard in VS2008 to push changes to my hosting provider. It doesn't look like those settings go with the project (which seems a little silly to me), but rather they go with the machine. On each new machine that…
Dan Esparza
  • 28,047
  • 29
  • 99
  • 127
1
vote
2 answers

Create SQL Server Deployment script using database publishing wizard

I'm getting the following error when using the Database Publishing wizard to script a SQL Server Express database for deployment. I have googled for hours unsuccessfully. Anyone had this isssue or know how to solve it? Timeout expired. The timeout…
Nicholas
  • 1,740
  • 5
  • 22
  • 31