Wednesday, March 7, 2012

I need to generate the query to build a database ive designed. Please help..

I've registered with GoDaddy for my site. I've used Visual Web Dev 2005 with SQL Server Mgmt Express 2005 to create my database etc. Now with GoDaddy, I need to "recreate" the database on their server again, but I don't want to go throug the whole process again. I just want to use their query editor to generate the database online.

GoDaddy mentions a "personal-sql" file that SQL Server 2000 generates, but I can't find anything like that with what I have.

Thanks.

Did you try automatically generating the scripts?

In Studio Express, right click on your database.

Select Tasks...Generate Scripts...

You can also generate scripts on a table by table basis.

No comments:

Post a Comment