Showing posts with label diagram. Show all posts
Showing posts with label diagram. Show all posts

Wednesday, March 21, 2012

From Visio 2003 to SQL

I am in the process of creating another database for one of our departments, I'm creating a diagram of the structure in visio 2003. I'm done with the diagram but when I try to export to sql it wont let me. Anyone ever had this problem before??
This is the Error message I'm getting

ODBC Error: 01000
[Microsoft][ODBC SQL Server Driver][SQL Server]Warning: The table 'Audit_Tbl' has been created but its maximum row size (20070) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.This just means that SQL got grumpy because the datatypes that you have chosen for this one table result in a table bigger than it likes. It gives you the warning about inserts and updates but in my experience inserts and updates still work. I was on a project where I had to break up a bunch large tables that exceeded the maximum field length to fix the design but the application still worked before I got there. One thing I did notice is that DTS may not work sometimes in tables that exceed 8060. Your table should have still been created or altered or whatever. this is just a warning.

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