SQL Server :: Best Free Software For DataBase Diagram E/R
Jan 26, 2011Some one know how is the best program for design database structure?
View 4 RepliesSome one know how is the best program for design database structure?
View 4 Replieswhen make buakup to my data base and open the database digram this error appear : Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
View 1 RepliesWe have been assigned a project for future developement. The problem is original developer did not create any data model, so we are in trouble understanding how db structure flow goes. I know we can create database diagram (even did that), but db contains 162 tables so the db diagram becomes so big that it does not fit in the monitor's view. Viewing each table > keys (for relationships) is not possible.
View 1 RepliesOn a home PC I have SQL Server 2005 installed. If I go to SQL server management studio and select my database, I can then right click on the "Database Diagrams" folder and then select "New Database Diagram" from the popup menu. I can then generate a database diagram. However on my PC at work if I follow the same steps as above, the popup menu does not show an option for "New Database Diagram". Instead my choices are "Working with SQL Server 2000 diagrams" and "Refresh". So why is the "New Database Diagram" menu option missing? Also what is odd is that the popup selection reads "Working with SQL Server 2000 diagrams" when in fact I am using SQL Server 2005 not 2000? Does anyone know why my option to create a database diagram is missing?
View 1 RepliesHow do you import database diagram at SQL Server Management Studio Express (SSMSE)? Using SSMSE in checking my database through a shared server, the "Database Diagrams" folder has no import functionality.
View 1 RepliesI have a drive 'F' with 40G free space. I try to restore a database whose data + log file size is 60G.
The restore fails. Is it because a full restore needs free disk space of 60G in this case?
I know that I can convert a sequence diagram into a collaboration diagram easily using Rational Rose, but... Using Visual Studio, that is possible? Or I will have to create by myself?
View 1 RepliesOpening an existing asp.net 3.5 project using VWD Express 2010, the database diagram file under Database Diagrams folder went missing in Database Explorer tab. Everything is in there when I first created the diagram using VWD Express 2008. However, when I look at the .dbml file, the associated relationship between dozens of tables exist and my project runs successfully. I'm planning to create another table with relationships from existing tables but seems like I have to painfully recreate them back from scratch. How can I recover those diagrams?
View 1 RepliesI have a table setup in the database for users who are basically going to create a classified listing. How can I setup a diagram that would easily create a table relationship with the Users table, so that it automatically inserts the users username when they submit a new ad? If so, how? I've tried adding a UserName row to my table and creating a relationship with the Users table "UserName" row, but it wasn't accepting the relationship when I tried to save the diagram...apparently because the UserName row in the Users table isn't a primary key?
Also, one this is setup, what's the best way to provide the user a way to see a list of their ads and have the ability to edit them?
I have one asp.net 2.0 application with MS Sql 2005 database.. As i deploy this database with client Machine.. now what i need is i need to take a backup of MS Sql 2004 database.. so is that any free tool is available which take daily backup...
View 16 RepliesI have a text area that allow user the type in an address in free format, how do I parse the address user entered into address1, address2, city, state, zip and country and save into DB?
View 4 RepliesI did try to find a more suitable place for this question, and contemplated posting it on Server Fault, but since there's no real "fault" here, I chose to ask it on S/O.Does anybody know of any free alternatives to the free Abyss Web Server X1 app, that actually work?
View 1 RepliesIm using asp.net 2.0 with Visual studio 2005... My requirement is i want to show my balance sheet from MS SQL 2005 database to graphical Chart... so Would u guyz will let me know the best high qulaity chat which support asp.net 2.0 with Visual studio 2005..
View 3 RepliesI have configured gmail's free smtp server for my web app and previously I was using smtp server configured at the server.
So I have changed my smtp settings accordingly but my app isn't sending any email and giving me error connection time out, third party tool isn't responding after many retrials.
Here are my settings-
SmtpClient smtpClient = new SmtpClient("mail.MyWebsiteDomainName.com", 25);
smtpClient.Credentials = new System.Net.NetworkCredential("info@MyWebsiteDomainName.com", "myIDPassword");
smtpClient.UseDefaultCredentials = true;....
Is there any free library for create xls files in asp.net on a server without office?
View 4 RepliesI am working on a tool to construct a diagram in asp.net .The user is allowed to select the images from panel [generated dynamically based on user input in dropdown box] and its copy should be created on the diagram area, it should be draggable and should over lay with each other . So far I am able to create the diagram objects dynamically and on click on each object its copy will be created on the diagram area [I am passing the instance from user control to main page] . I have used Drag Drop Extender to apply Drag behavior. Now my problem is which I create more objects the position of already created objects is not retained in the page. I have js code to retain the position for static controls, but don’t know how to apply for dynamic controls.
[Code]....
Am I complicating the whole process ,is there any easy way? .
I'm a novice developer writing an ASP.NET application with VB. I'm having a little trouble getting my head around the partial class concept. If you use the partial classes as a code-behind for the presentation, how would these be represented in UML, in particular with a class diagram?
View 2 Repliesit is very hard to read exist asp.net code. but view diagram is very easy. explain about convert asp.net code to diagram.
View 3 RepliesIn diagram of SQL 2008, I have 3 table : tbl_Events, tbl_Products, tbl_Product_Events.When I create MyDBModel.edmx (ADO.Net Entity Data Model) at VS 2010, diagram model display 2 tbl_Events and tbl_Products.It is difficult to access data.This is diagram in SQL 2008 and here is diagram in VS 2010
View 6 RepliesI am creating an web application for my tae kwon do club. People are able to register online for a tournament. After the registration deadline the web application generates a dendrogram. Something like this: how to draw it. Because of the fact that there are my weight and age categories i have to draw them dynamicly for each group.What is the easiest way to draw this inside a MVC view?
View 2 RepliesOrg chart for site in ASP.NET, C#
i want to create orgchart like this [URL]
can any one tell me that how can i implement this tool in my website and also fill this diagram with database
I need to create Visio diagrams on the server-side. But Microsoft strongly discourages usage of automation in server scenarios.
What should I be looking at? (SharePoint 2010 services is not an option for me).
there is any free Rick Text Editor server control available for web, note that I am not asking about DHTML controls like FreeTextBox and similar.
View 9 RepliesI have been tasked to create a simple box-to-box diagram using some data I retrieve from a SQL database. I will have to apply text tag names to the boxes and connectors.
Anyone ever build a Visio diagram dynamically on a web page?
I have a solution consisting of many projects. it's very hard to trace your way around to find the right class or method to change , which led me to try to create a diagram that can model the whole solution. Is there a tool in visual studio ( class diagram designer or rational rose ) or even a third party tool that can revers engineer the solution and generate a class diagram, including all the classrelations,compositions,hierarchies and etc.
View 1 Replies