Member Avatar for dadahetal

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?

  • 3 Contributors
  • 2 Replies
  • 89 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by greeny_1984
Member Avatar for achristov

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

Member Avatar for greeny_1984

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.