Putting SQL Server 05 database on GoDaddy server. Argh!!!

I have a simple Website and Database created in VWD exp.

I've just added a windows account to GoDaddy.com.

Unfortunately there is no way to port your database on to the GoDaddy server directly, but it says you must instead, recreate the database by copying and running SQL statements from a file called "personal-add.sql". (their "help" page: http://help.godaddy.com/article.php?article_id=695)

I can't find any such file. Can someone please let me know what I'm missing here?

Thanks.

Hi Brad -

You should take a look at the Database Publishing Wizard, available at http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard&referringTitle=Home. We actually have a guide on how to upload databases using the tool to shared hosters like GoDaddy... see http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Tutorials&referringTitle=Database%20Publishing%20Wizard.

Let me know if you have any issues.

Thanks,

alex

|||

alex wrote:

Hi Brad -

You should take a look at the Database Publishing Wizard, available at http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard&referringTitle=Home. We actually have a guide on how to upload databases using the tool to shared hosters like GoDaddy... see http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Tutorials&referringTitle=Database%20Publishing%20Wizard.

Let me know if you have any issues.

Thanks,

alex

Thanks for this, for those that are in the same situation as me, a useful program is The SQL Server Database Publishing Wizard

Pulling stored Procs from a remote db

Hi all -
I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used under it at the host. I can get at the db by using
Access/ODBC with a URL but the migration facility seems only to let me get
at the tables.
There are about half a dozen SPs referred to in the ASP code ( eg EXEC
sp_www) and I want to get hold of the code as I am not sure at all what they
are doing.
How do I get the code for each SP and store it in the local copy of the db?
Can I just replicate the db and move the replica to a local area?
Any advice on this gratefully (!) receive
Thanks
Jim McDonaldYou can get the source code of a stored procedure using sp_helptext.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jim McDonald" <jim@.missile.demon.co.uk> wrote in message
news:ct7q5g$n7j$1$8302bc10@.news.demon.co.uk...
> Hi all -
> I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used
> under it at the host. I can get at the db by using Access/ODBC with a URL
but the migration
> facility seems only to let me get at the tables.
> There are about half a dozen SPs referred to in the ASP code ( eg EXEC sp_
www) and I want to get
> hold of the code as I am not sure at all what they are doing.
> How do I get the code for each SP and store it in the local copy of the d
b? Can I just replicate
> the db and move the replica to a local area?
> Any advice on this gratefully (!) receive
> Thanks
> Jim McDonald
>

Pulling stored Procs from a remote db

Hi all -
I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used under it at the host. I can get at the db by using
Access/ODBC with a URL but the migration facility seems only to let me get
at the tables.
There are about half a dozen SPs referred to in the ASP code ( eg EXEC
sp_www) and I want to get hold of the code as I am not sure at all what they
are doing.
How do I get the code for each SP and store it in the local copy of the db?
Can I just replicate the db and move the replica to a local area?
Any advice on this gratefully (!) receive
Thanks
Jim McDonald
You can get the source code of a stored procedure using sp_helptext.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jim McDonald" <jim@.missile.demon.co.uk> wrote in message
news:ct7q5g$n7j$1$8302bc10@.news.demon.co.uk...
> Hi all -
> I am trying to rebuild a website abandoned by the builder and an SQLServer (I think 2k) db is used
> under it at the host. I can get at the db by using Access/ODBC with a URL but the migration
> facility seems only to let me get at the tables.
> There are about half a dozen SPs referred to in the ASP code ( eg EXEC sp_www) and I want to get
> hold of the code as I am not sure at all what they are doing.
> How do I get the code for each SP and store it in the local copy of the db? Can I just replicate
> the db and move the replica to a local area?
> Any advice on this gratefully (!) receive
> Thanks
> Jim McDonald
>

Pulling stored Procs from a remote db

Hi all -
I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used under it at the host. I can get at the db by using
Access/ODBC with a URL but the migration facility seems only to let me get
at the tables.
There are about half a dozen SPs referred to in the ASP code ( eg EXEC
sp_www) and I want to get hold of the code as I am not sure at all what they
are doing.
How do I get the code for each SP and store it in the local copy of the db?
Can I just replicate the db and move the replica to a local area?
Any advice on this gratefully (!) receive
Thanks
Jim McDonaldYou can get the source code of a stored procedure using sp_helptext.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jim McDonald" <jim@.missile.demon.co.uk> wrote in message
news:ct7q5g$n7j$1$8302bc10@.news.demon.co.uk...
> Hi all -
> I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used
> under it at the host. I can get at the db by using Access/ODBC with a URL
but the migration
> facility seems only to let me get at the tables.
> There are about half a dozen SPs referred to in the ASP code ( eg EXEC sp_
www) and I want to get
> hold of the code as I am not sure at all what they are doing.
> How do I get the code for each SP and store it in the local copy of the d
b? Can I just replicate
> the db and move the replica to a local area?
> Any advice on this gratefully (!) receive
> Thanks
> Jim McDonald
>

Pulling stored Procs from a remote db

Hi all -
I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used under it at the host. I can get at the db by using
Access/ODBC with a URL but the migration facility seems only to let me get
at the tables.
There are about half a dozen SPs referred to in the ASP code ( eg EXEC
sp_www) and I want to get hold of the code as I am not sure at all what they
are doing.
How do I get the code for each SP and store it in the local copy of the db?
Can I just replicate the db and move the replica to a local area?
Any advice on this gratefully (!) receive
Thanks
Jim McDonald
You can get the source code of a stored procedure using sp_helptext.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jim McDonald" <jim@.missile.demon.co.uk> wrote in message
news:ct7q5g$n7j$1$8302bc10@.news.demon.co.uk...
> Hi all -
> I am trying to rebuild a website abandoned by the builder and an SQLServer (I think 2k) db is used
> under it at the host. I can get at the db by using Access/ODBC with a URL but the migration
> facility seems only to let me get at the tables.
> There are about half a dozen SPs referred to in the ASP code ( eg EXEC sp_www) and I want to get
> hold of the code as I am not sure at all what they are doing.
> How do I get the code for each SP and store it in the local copy of the db? Can I just replicate
> the db and move the replica to a local area?
> Any advice on this gratefully (!) receive
> Thanks
> Jim McDonald
>

Pulling HTML out of a Database

Good Morning,

I'm not quite sure this is the right place to post this, but i'll try anyway.

I have a website where I allow people to create their own layouts in HTML, and in the HTML I have them placeing markers (eg. |1| ) where they would like to place something from a database. All the HTML is stored in a SQL Server DB, and when I pull it out, it's fine, except it won't allow me to Replace any of the markers with values from the DB.

Here's and example line of HTML that's held in the DB:

<table width='50%' border='1'><tr><td>|0|</td><td>|1|</td></tr>

and when I do a strHtml.Replace("|0|", dReader["somefield"].ToString()) or even just a strHtml.Replace("|0|", "Test") it never changes it.

Anyone have any ideas?

Thanks,

Deepthought

String.Replace returns a new string with the values replaced. Should be doing something like this in your code

strHtml= strHtml.Replace("|0|", dReader["somefield"].ToString())