generate sql script

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

Join Date: Apr 2009
Posts: 2
Reputation: dadahetal is an unknown quantity at this point 
Solved Threads: 0
dadahetal dadahetal is offline Offline
Newbie Poster

generate sql script

 
0
  #1
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?
Reply With Quote Quick reply to this message  
Join Date: Mar 2008
Posts: 68
Reputation: achristov is an unknown quantity at this point 
Solved Threads: 5
achristov's Avatar
achristov achristov is offline Offline
Junior Poster in Training

Re: generate sql script

 
0
  #2
Apr 26th, 2009
Maybe you mean Visual Studio 2005? You can't - use SSMS (SQL Server Management Studio).
Alexander Christov,
www.achristov.info
Reply With Quote Quick reply to this message  
Join Date: Apr 2007
Posts: 370
Reputation: greeny_1984 is an unknown quantity at this point 
Solved Threads: 29
greeny_1984's Avatar
greeny_1984 greeny_1984 is offline Offline
Posting Whiz

Re: generate sql script

 
0
  #3
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
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



Tag cloud for ASP.NET
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC