ASP.NET

generate sql script

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Apr 2009

Posts: 2

Reputation: dadahetal is an unknown quantity at this point

Solved Threads: 0

dadahetal

Offline

Newbie Poster

generate sql script

Apr 25th, 2009

I have created Database. table and procedure inside that. I want to generate sql script for this. How can I do that in .Net 2005?

also after generating script, how can i run that to create tables in another computer?

•

Join Date: Mar 2008

Posts: 68

Reputation: achristov is an unknown quantity at this point

Solved Threads: 5

achristov

Offline

Junior Poster in Training

Re: generate sql script

Apr 26th, 2009

Maybe you mean Visual Studio 2005? You can't - use SSMS (SQL Server Management Studio).

Alexander Christov,
www.achristov.info

•

Join Date: Apr 2007

Posts: 370

Reputation: greeny_1984 is an unknown quantity at this point

Solved Threads: 29

greeny_1984 greeny_1984 is offline

Offline

Posting Whiz

Re: generate sql script

Apr 27th, 2009

Hi,

Do you want to generate sql script for a database table in sql server 2005 ,then follow these steps
1.open microsoft sql sever 2005
2.open management studio express
3.go to your database
4.right click on the table you want to generate script
5. go to option "script table as"
6. select option "create to"->"new query editor"
7.it will generate script
8.copy this query and execute in the database you want to have this table.

If u r query is achieved,mark the thread as solved

Live and Let Live