How to develop database locally and post to web host?

30 Mar 2006 6:11 AM

Noozer

I have MSSQL 2005 Express installed locally. I've developed a database and
would like to copy it to my web host to be accessed using some ASP code.
Everything appears to be OK, except for one issue that I can't figure out.

HOW do I take my local database and upload it to my host?

I do have the MS SQL Server 2005 Express Manager installed and can connect
to both my local SQL 2005 server and my hosts SQL 2003 server.

How are databases normally developed for web applications?

30 Mar 2006 6:34 AM

Jens

Hi,

"SQL 2003 server." There is no SQL 2003 Server. If your hoster doesn´t
offer you to restore backups you ade on your test system. You can
either use scripts changing your database which can be applied on the
server, or you can transfer objects to your hosters db. I am alqys
doing a whole *backup* (with transfering the database objects to my
local machine) doing changes and reapply them on the *productional*
server.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

30 Mar 2006 8:48 AM

hongju

You can backup local database and restore on the host database.
If you developed database file using Visual Studio, you can attach database
on the host.
And can modifiy connection string.

"Noozer"ë‹˜ì´ ìž‘ì„±í•œ ë‚´ìš©:

Show quote

> I have MSSQL 2005 Express installed locally. I've developed a database and
> would like to copy it to my web host to be accessed using some ASP code.
> Everything appears to be OK, except for one issue that I can't figure out.
>
> HOW do I take my local database and upload it to my host?
>
> I do have the MS SQL Server 2005 Express Manager installed and can connect
> to both my local SQL 2005 server and my hosts SQL 2003 server.
>
> How are databases normally developed for web applications?
>
>
>

15 Jun 2006 9:09 PM

Michelle

Hongju - can you be a little more specific on how to back up and restore the
databases. I have a very similar problem. I created a project that has a
database in APP_DATA. I'm hosting on GoDaddy and I need to take the APP_DATA
database (.mdf) and move it to one of their MySQL databases. I have no clue
on how to do that. Any help would be greatly appreciated.

Thanks

Show quote

"hongju" wrote:

>
> You can backup local database and restore on the host database.
> If you developed database file using Visual Studio, you can attach database
> on the host.
> And can modifiy connection string.
>
> "Noozer"ë‹˜ì´ ìž‘ì„±í•œ ë‚´ìš©:
>
> > I have MSSQL 2005 Express installed locally. I've developed a database and
> > would like to copy it to my web host to be accessed using some ASP code.
> > Everything appears to be OK, except for one issue that I can't figure out.
> >
> > HOW do I take my local database and upload it to my host?
> >
> > I do have the MS SQL Server 2005 Express Manager installed and can connect
> > to both my local SQL 2005 server and my hosts SQL 2003 server.
> >
> > How are databases normally developed for web applications?
> >
> >
> >

15 Jun 2006 9:17 PM

MatsL@newsgroups.nospam

Moving it to a MySQL database might take a little more work. Use the
"Generate scripts..." function in Management Studio and run those script
in the mysql database.
You will most likely need to modify them some to get them to work.
It's probably a good idea not to generate scripts for everything at
once, but to start with the tables first, then the views, then the SP's
etc etc...

Michelle wrote:
Show quote

> Hongju - can you be a little more specific on how to back up and restore the
> databases. I have a very similar problem. I created a project that has a
> database in APP_DATA. I'm hosting on GoDaddy and I need to take the APP_DATA
> database (.mdf) and move it to one of their MySQL databases. I have no clue
> on how to do that. Any help would be greatly appreciated.
>
> Thanks
>
> "hongju" wrote:
>
>> You can backup local database and restore on the host database.
>> If you developed database file using Visual Studio, you can attach database
>> on the host.
>> And can modifiy connection string.
>>
>> "Noozer"ë‹˜ì´ ìž‘ì„±í•œ ë‚´ìš©:
>>
>>> I have MSSQL 2005 Express installed locally. I've developed a database and
>>> would like to copy it to my web host to be accessed using some ASP code.
>>> Everything appears to be OK, except for one issue that I can't figure out.
>>>
>>> HOW do I take my local database and upload it to my host?
>>>
>>> I do have the MS SQL Server 2005 Express Manager installed and can connect
>>> to both my local SQL 2005 server and my hosts SQL 2003 server.
>>>
>>> How are databases normally developed for web applications?
>>>
>>>
>>>