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?
dadahetal
0
Newbie Poster
Recommended Answers
Jump to PostMaybe you mean Visual Studio 2005? You can't - use SSMS (SQL Server Management Studio).
All 2 Replies
achristov
12
Junior Poster in Training
Maybe you mean Visual Studio 2005? You can't - use SSMS (SQL Server Management Studio).
greeny_1984
14
Posting Whiz
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.