Monday, March 19, 2012

From databasediagram to T-SQL

Hello, i have made a diagram in a SQL Express database.
i would like to know how to get this to T-SQL CREATE TABLE script?
Cool [H]I don't think you can use SQL Express to do it but we are still in beta so use the link below and download the developer edition to do it. How you use the OLTP(online transaction processing) management studio it is like your Enterprise manager in SQL Server 2000. Hope this helps.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx#EBAA|||

Thanks i understand. I think this is a pretty imporant feature. Because if i have made a Table Diagram in VWD and would like to show it to a friend, i want to be able to convert this diagram to a SQL CREATE TABLE txt script. so my friend can just copy this SQL txt script into his VWD and show up exactly the same tables.

|||Hello, i noticed that i actually can get this diagram to a T-SQL CREATE TABLE script, by clicking on the "Generate change script", but this "menubutton" is only available if i made a change to the database, and because of this i cannot just generate the script when i want to, i have to make changes to the database to do it, i think this is a unnecessary step, this "menubutton" "generate change script" should be available all the time, and it should be renamed to "generate script" so i can generate the T-SQL script whenever i want to.|||Try the post below and test drive the latest CTP, it may be different. Hope this helps.
http://forums.asp.net/1052509/ShowPost.aspx

No comments:

Post a Comment