How to develop database locally and post to web host?

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_DAT
A
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 databas
e
> on the host.
> And can modifiy connection string.
> "Noozer"?? ??? ??:
>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:
> Hongju - can you be a little more specific on how to back up and restore t
he
> 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_D
ATA
> database (.mdf) and move it to one of their MySQL databases. I have no cl
ue
> on how to do that. Any help would be greatly appreciated.
> Thanks
> "hongju" wrote:
>

How to determine what patches are needed to restore Master

I have had to rebuild our SQL server from scratch due to hardware failure.
Because of a version mismatch... this has presented a problem to me in
restoring the Master database. The previous admin did not leave notes on
what patches were installed on the server, and all that I know is SP1 was
installed minimum.
I have since installed SP1, but I seem to be missing a couple more patches.
Is there any way to determine what patches I need from the error message
given during restore? Current version: 134218112 Master Database
Version: 134218262
Thank you all in advance for your assistance.Was able to extract the actual software version information...
The current software version is: 8.00.384
The backup Master version is : 8.00.534