CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:
Zone: > NEWSGROUP > Asp.Net Forum > windows_hosting.hosting_open_forum Tags:
Item Type: NewsGroup Date Entered: 8/18/2007 12:34:59 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 2 Views: 15 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
3 Items, 1 Pages 1 |< << Go >> >|
biobot
Asp.Net User
database deployment problems8/18/2007 12:34:59 AM

0/0

Hello,

Here are my methods used to deploy a database on Go Daddy Windows shared hosting service:

1) using aspnet_regsql.exe -A all -sqlexportonly example.sql -d databaseownername

With that I go to my host and enter the text into a Query Analyzer, but I get an error message stating that "string or binary data will be truncated" (I have tried a shorter name string) If I try to ignore this, the app fails.

2) using SqlPubWiz and again uploading the text to the Query Analyzer.

With that, I get an error from the QA stating that there is a "syntax error near END." Again if I try to ignore this, the app fails.

Some of you may have seen this,  or very similar from me already - please excuse my ineptitude!

Thanks in advance for any help offered!

biobot

biobot
SalmonTraining
Asp.Net User
Re: database deployment problems8/18/2007 10:41:54 AM

0/0

1) You can't do it this way - as you're finding out. The aspnet_regsql.exe is an executable that you would need to run from the command line on the host server - you don't get privileges to do so on shared hosting plan.

2). Using the Database Publishing Wizard is the best way. Unfortunately, the Query Analyser GUI has a few glitches when it interprets standard Transact-SQL statements. I've noticed that Go Daddy has upgraded the interface recently and I have less issues now with running scripts - but sounds like you're tripping over a problem.

Specifically, a known problem with Query Analyser is with the keyword GOTO at the start of a line. Check out this article for a description and work-around of the problem: http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Tutorials

If you've looked at the script generated by the Wizard you'll see that it creates your data model step by step. I suggest you run it in sections. In particular, from the error you mention, I think the script is failing on creating a stored procedure. I suggest you run the script up to the section that starts creating stored procedures (and I just mean copy-and-paste the text up to that point, or split the script into two files). Then run each procedure creation individually to get to your problem. Once you've isolated what's falling over, post it to the SQL Server forum within forums.asp.net with the specific problem and someone will help you clean up the script (mention it's Go Daddy, there's a few of us who regularly work with that hosting provider and have experienced your problems).

Articles & Training for SQL Server and ASP.Net 2.0

Check out our tutorials for going live on GoDaddy
biobot
Asp.Net User
Re: database deployment problems10/8/2007 7:21:29 PM

0/0

Hi,

Thank you for responding, and please excuse my slow response - other committments.

I have elected to cancel my Go-Daddy account for the time being, and to confine my efforts to a local machine.

At this point, I'm wondering whether Go-Daddy is really any different than other shared hosting providers? I notice there are thousands of reported issues, but that may be due to its widespread use.

If I go back to them, I will check out the tutorials you've recommended.

Regards

biobot
3 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
ASP.NET Website Programming: Problem - Design - Solution Authors: Marco Bellinaso, Kevin Hoffman, Pages: 576, Published: 2002
Agile Database Techniques: Effective Strategies for the Agile Software Developer Authors: Scott W. Ambler, Pages: 447, Published: 2003
Beginning ASP.NET 2.0 Authors: Chris Hart, John Kauffman, Chris Ullman, David Sussman, Pages: 759, Published: 2005
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET Authors: Dejan Sunderic, Pages: 664, Published: 2006
ASP.NET 2.0 Website Programming: Problem-design-solution Authors: Marco Bellinaso, Pages: 576, Published: 2006
Data Management Handbook: Handbook Authors: Sanjiv Purba, Pages: 1021, Published: 1999
Information Security Management Handbook Authors: Harold F. Tipton, Micki Krause, Pages: 3231, Published: 2007
SQL Server 2000 Stored Procedure & XML Programming: Stored Procedure & XML Programming Authors: Dejan Sunderic, Pages: 679, Published: 2003
UML 2 For Dummies Authors: Michael Jesse Chonoles, James A. Schardt, Pages: 412, Published: 2003

Web:
Source Code Management and Database Deployment Jun 16, 2005 ... Source Code Management and Database Deployment. ... The problem that you will face relatively often is that, while you develop your database ...
Recipe: Deploying a SQL Database to a Remote Hosting Environment ... I'll then loop you in with someone on the SQL Database Deployment team who can ..... Let me know if this works or if you have any problems with it and I can ...
Database Deployment with Unit Tests + Data Dude No problem I thought, there is a pre-deployment script feature in DataDude, I can just add some script there with the DROP DATABASE logic. ...
Easily Deploy Databases to SQL Server with No Scripting Dynamically and programmatically deploy SQL Server database structures without the use ... and upgrades and alleviates many potential installation problems. ...
deployment database: Definition from Answers.com deployment database (DOD) The Joint Operation Planning and Execution System database containing the necessary information on forces, materiel, and.
SSW SQL Deploy - Database Deployment Tool for SQL Server and MSDE SQL Deploy solves this problem by automatically performing Database updates as a part of your application deployment. Bundle SSW SQL Deploy when you ...
Vs2008 Database deployment problem - DevX.com Forums Vs2008 Database deployment problem .NET. ... HTML code in database field problem , Wildcatbob, VB Classic, 2, 01-27-2006 08:38 AM ...
MSDN Visual Studio Team System - Database Professionals A ... I'm getting the same problem with roughly the same type of configuration. It is absolutely set to "Create a deployment script (sql) and deploy to database. ...
Becoming Agile: Agile Database Deployment Agile Database Deployment. A common problem in enterprise software development is how to manage database structure changes. In some environments this ...
2008-09 Automated Database Deployment Synchronization of the development and production database (the very database deployment process) is considered as minor problem and usually left to the ...

Videos:
Java ME and the Netbeans Mobility Pack Google Tech Talks May 3,2007 ABSTRACT NetBeans Mobility Pack is a development environment for Java ME CLDC/MIDP, CDC developers. In this talk Marti...
Java ME and the Netbeans Mobility Pack Google Tech Talks May 3,2007 ABSTRACT NetBeans Mobility Pack is a development environment for Java ME CLDC/MIDP, CDC developers. In this talk Marti...
Programming and meeting deadlines Bob and Yvo discuss deadlines and coding, it's tough to get projects done in time!
Access 2000 Dev Level 16 The Access 2000 Dev Level 16 is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-based information technology course tit...
Servoy zero deployment aberdeen sql Bob and Yvo talk about desktop databases and zero deployment
Access 2000 Dev Level 16 The Access 2000 Dev Level 16 is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-based information technology course tit...
Applying the Planner ESU to a 8.11SP1 Deployment Server http://jde.informedcio.com In the video series we are upgrading an 8.11 SP1 installation from SQL 2000 to SQL 2005. Prior to completing the database...
Access 2000 Dev Level 16 The Access 2000 Dev Level 16 is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-based information technology course tit...
Upgrading the Deployment Server to Tools 8.97.1.1 http://jde.informedcio.com In the video series we are upgrading an 8.11 SP1 installation from SQL 2000 to SQL 2005.Prior to completing the database ...
Morph Appspace Deployment Demo for Java This means that all of those Java programmers out there now have a place to easily run their web applications without having to deal with infrastruct...




Search This Site:










thoughts on upgrading vs. rebuild of my site?

help configuring for web matrix (no iis)?

refreshing page

podcasting with dnn

code snippets in c#

how to center a panel with controls horizontally in a page?

merging text and strings to one string

customize toolbox

bg images to menu

customer control in design view?

reg master pages

how to store-retrieve hidden form field values from code behind?

localization and generate local resource

best method to implement authentication

web services in dotnetnuke

template editor

important question eula and gpl.

passing the values between two webpages

using an asp function in asp.net

web database -->> office database

how to compile web user control from web page?

newbie question on custom control's

sending emails

declaring multiple variables...

connection sql server 2005

vs 2005

how do i link to an aspx page from a regular html page? helllpppp!

this is kinda complicated so bear with me....

debugging custom modules

most of my edit functions are de-activated (greyed out) for a specific application being developed
 
All Times Are GMT