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.
CREATE TABLE employees ( employee_number char(6) NOT NULL , known_as char(20) , surname char(20) , job_title char(20) , manager_number char(6) NULL , unique_identifier char(6) NOT NULL PRIMARY KEY ) --unique_identifier is in the format 000123456789
Now I have a conundrum when trying to create organization charts in Visio, so I figured I'd try reproduce the format that a bunch of walkthroughs suggest, which is with the first column being an int identity(1,1) column as the employeeID with the managerID being an int column also, referencing the employeeID. Hope I've not lost you just yet ;) So here's what I figured - create a new table with the new integer columns, slap my current data into it and then update the managerID as necessary...
Except I can't work out the update statement for this!
CREATE TABLE gvVisioTest ( employeeID int identity(1,1) , employee_number char(6) , job_title char(40) , department_reference char(10) , managerID int , manager_number char(6) ) GO
INSERT INTO gvVisioTest(employee_number, job_title, department_reference, manager_number) SELECT employee_number, job_title, department_reference, manager_number FROM employees GO
--Update managerID with relevant employeeID GO
DROP TABLE gvVisioTest
Any ideas?
Oh and this is legacy so the design is flawed, modified over time (the manager field is a bodge put in 5 years ago), so yeah unfortunately I have to work with what I've got :(
I am trying to generate a report from the database. I am using Visio 2010. I would like to include the table names, column names , column types and the comments that I entered in the NOTES field associated with the tables and columns. Basically, I would like to generate a data dictionary report.
I am having data model diagram containing 150 odd tables in MS Office Visio 2007.The Datamodel Diagram even has the Relationships between the Tables.
Do we have any Procedure to export the Datamodel Diagram from the Visio to the Sql Server carrying all the relationships.
We are having the reverse engineer procedure to export database diagrams from Sql server to the datamodel diagram in the Visio in the same way, do we have any procedure to Export DataModel diagram from Visio to SQL Server to create tables with all the relationships?
Is it possible to import the SSIS workflow diagram into visio? Is there a way to extract the images and import them into SSIS for use with creating a workflow, or better yet, is there a way to re-engineering the workflow in SSIS with Visio?
For an initial step, I would like to re-create the SSIS workflow in Visio for presentations.
I'm running Visio 2003 on Windows XP with SQL Server 2005 Express rather than MSDE. Is this configuration supported? If yes, how does the SQL database get built since SSADMIN.exe (delivered with the Visio SDK) does not detect an MSDE compatible database when SQL Server 2005 Express is not installed?
Hi, i want to do the physical modeling using MS Visio. Whether is it availble with Microsoft Visual Studio 2005 or not?? If Yes, Could you please asssit what necessary loaded with Studio and Version Details.
Data mining add-in for Office Visio 2007 is great. But what I am concerning is-to end users (to technical users) how could we deliver the data mining models results in a better way (e.g. integrate with other possible clients ) to make it dynamically and easily undertood?
I'll try to explain what I'd like to do. On my SQL Server 2005, SSAS contains a mining model (In fact a cluster one). I'd like to show a detailed diagram build from this model on a web site. This diagram (and this is why I need automation) would depend on the user who's consulting it. For example, a firm A will see the number of its customers in each cluster, and this information will be different for another firm B
So, I thought about several steps to perform: 1) Feed the model with the data for each firm 2) Build a Visio diagram from the previous data using the DM addins for Visio 2007 3) Generate HTML using the Visio export wizard 4) Publish HTML And (important) this should be done automatically.
I made some experiments: Step 1 is easy to perform with SSIS Step 3 is also easy to do with the Visio SDK (using, among others, the exportAsHtml control) and Step 4 is trivial
I failed to perform stage 2, even with the SDK, since creating a diagram from a DM template requires the user to fill a wizard. By code, I'm able to create a document from a DM template, Drop a DM Stencil but when the wizard appears I'm unable to get a handle on it. And even if I was, I dunno if it would be a "clean" way of doing.
So my question is: first of all: isn't there an easier way to generate HTML from Mining Models automatically? And if my approach to this problem is the best (or the "least bad"), how to generate datamining Visio diagrams from code automatically?
Programmatically generating HTML visualizations of models using DM Add-ins the thread in sqlserverdatamining.com contains a code block listed below. This code doesn't work it fails in the statment : "helper.DrawDecisionTree(helper.ActivePage, parameter);" . It says "Visio rendering failed"..
I didn't understand the part "parameter.ConnectionName = "AdventureWorksConnection";" in the code block. Which type or object is expected by parameter.ConnectionName ? An Adomdconnection or Oledbconnection. Type is string but does it expect us the name of connection? Please help me because i didn't figure out the solution.
By the way i'm using Visio2007 and installed everything which has told in the article and added as reference.
Code Block using System; using System.Collections.Generic; using System.Text; using System.IO; using Microsoft.SqlServer.DataMining.Office.Visio.Programability;
namespace DMDigramUsingViso { class Program { //This is the folder where the data mining addins have been installed. public const string DMAddinInstallPath = @"C:Program Files (x86)Microsoft SQL Server 2005 DM Add-Ins";
//This is the name of the Visio template file for the data mining addins. public const string VisioTemplateName = @"Microsoft Data Mining.vst";
//This is the name of the target HTML file. public const string WebFileName = @"TargetMail.htm";
//---------------------------------------------------- // Create the parameter object for the decision tree // drawing and populate the required parameters //---------------------------------------------------- ParameterDecisionTree parameter = new ParameterDecisionTree(); //Friendly name for the connection parameter.ConnectionName = "AdventureWorksConnection"; //Name of the Analysis Server parameter.DataSourceName = "localhost"; //Name of database parameter.CatalogName = "AdventureWorks"; //Name of the mining model parameter.ModelName = "Target Mail"; //Name of the decision tree predictable parameter.TreeName = "Bike Buyer"; //Flag to hide the progress dialog parameter.Silent = true;
//---------------------------------------------------- // Optional properties for the parameter object //---------------------------------------------------- //Shade tree nodes using support parameter.GradientType = GradientType.SupportGradient; //Show support in the nodes parameter.ShowSupport = false; //Fill color for the nodes parameter.FillColorArgb = System.Drawing.Color.Aqua.ToArgb(); //Fill pattern color for the nodes parameter.PatternColorArgb = System.Drawing.Color.Azure.ToArgb();
//---------------------------------------------------- // Drawing helper object which performs the actual rendering //---------------------------------------------------- DMDrawingHelper helper = new DMDrawingHelper(visioFile, false); //Start the Visio application helper.Start();
/* Helper object allows access to Visio object model using the following methods: helper.CreateNewDocument(); helper.CreateNewPage(); helper.ActiveDocument; helper.ActivePage; helper.Application; */
//Render the decision tree on the current active page Console.WriteLine("Rendering decision tree using the visio engine..."); helper.DrawDecisionTree(helper.ActivePage, parameter);
//Convert all the pages of the drawing to HTML Console.WriteLine("Converting to HTML using the visio engine..."); helper.SaveDocumentAsWebPage(helper.ActiveDocument, -1, -1, webFile, DMDrawingHelper.ShowNavigationBar | DMDrawingHelper.ShowPanAndZoom | DMDrawingHelper.ShowPropertiesWindow | DMDrawingHelper.ShowSearchTool);
//Close the Visio App helper.Close(); Console.WriteLine("HTML File is generated at : {0}", webFile);
Hi, I need to import an SQL string from MS Excel 2003 to SQL SERVER 2000. The string I need to import is composed by 5 different several blocks and looks like:
The detail of the SQL string is at: http://forums.microsoft.com/msdn/showpost.aspx?postid=2093921&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1
I am trying to implement OJ's suggestion: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2117223&SiteID=1 to use multi - batch processing to import the string to SQL SERVER, something like:
Code Snippet Dim SqlCnt, cmd1, cmd2, cmd3 'set the properties and open a connection
cmd1="use my_db" cmd2="create table mytb" cmd3="insert into mytb"
I may not be the best forum for this post, however I believe some onecan still help me or direct me somewhere else.I'm finding that win 2003 x64 and SQL 2005 CTP is slower than win 2003and SQL 2000.Machine A: Opteron 2.2 (248) w/ 2 cpus. 8GB memory. SCSI disk array.Windows Enterprise 2003 x64 final release. SQL Server 2005 enterpriseCTP.Machine B: Opeteron 2.2 (248) w/ 2 CPUs. 4GB Memory. IDE Drives.Windows Server 2003 (32bit) and SQL Server 2005 (standard).I'm using Cognos' DecisionStream as the ETL tool (32bit). I have theidentical job on both machines. Machine A is slower to do my nightlybuild (1h 20m) vs. Machine B (50m).I've done no tweaking of the databases. I Used SQL 2005's studio tocopy the database from Machine B to Machine A.The only major difference is the O/S and SQL, the machines are samespeed, however Machine A has twice the memory and faster disk; so Iwould expect it to be faster.Can anyone think of smoking guns I might be missing?TIA
Can I use VB.NET 2003 with SQL Everywhere on desktop? Is it possible to create and populate data into .sdf with VB.NET 2003? Please advice, thank you very much.
We are running SQL 7, using Access 2000 as a front end. Our network personis wanting to migrate to Windows 2003 (we're currently on Windows 2000), andwants to know if we should migrate to SQL 2003 at the same time. Are theremajor changes between SQL 7 and SQL 2003, and how hard of a task would it beto migrate our single database to a new version of SQL?Thanks,Neil
Has anyone heard of any problems running SQL 7 under Windows Server 2003?We're upgrading to 2003 and are wondering if we can keep SQL 7 with the newOS.Question 2: If we upgrade SQL to SQL 2005, can I run our database in SQL 7mode? Or would it be better to just convert it to SQL 2005?Thanks!Neil
i've installed the SSRS 2000 ENT Edition i trying to add reportviewer dll in my webapplication but i haven't find that dll so could any help in this issue ?
I would like to install SQL express on a PC which already has SQL 2003 - I use enterprise manager to manage a database. I require express as part of a teaching role (my students have installed it). Is is possible to do this or should I remove the full version
Writing an installer to handle switching the DLLs depending on OS version is somewhat of a pain. The SQL CE dlls that we are told to install for PocketPC 2003 and WM5 PPC are different... but I noticed that the 2003 DLLs seam to work fine on a WM5 PPC. Is there a perf hit or some other problems I will run into for doing this that I just haven't hit yet? Will this work for any WM5 PPC?
How do i execute a SSIS package (dtsx) in vb.net 2003
i've tried
Dim app As Application = New Application Dim p As Package = app.LoadPackage(pkg, Nothing) p.Variables("varFileDirectory").Value = FileDirectory p.Variables("varUserID").Value = UserID p.Execute()
but it does not recognize Package. what do i have to import for Package to be recognized. Is there another way to execute a SSIS package from vb.net 2003?
I dont know if i am in the right place to post this.
Is there any release of SQL server called SQL server 2003. I came accross this in a couple of job descriptions and also in a couple of interviews that i had. I Have been working on SQL Server since SQL Server 6.5, but hadnt heard about any release by that name. I really appreciate it if some one could provide some information on this. Thanks in advance.
I have run into this issue repeatedly when installing applications on SBS 2003. The application needs a database and looks for one when installing. It sees the SQL 2000 databases pre-installed on SBS 2003 for monitoring and reporting and assumes it can use them. Ultimately the program grinds to a halt because these instances cannot be used for the application (I'm assuming). The program should install it's own instance of SQL . I end up spending quite a bit of time mending the installation by manually installing some "lite" version of SQL and piecing it to the application.
Is there anyway to use the existing SBS 2003 SQL databases for a new app, like a backup program? There is no SQL management software on SBS 2003, so how is that done? Should I always install a new instance of SQL server for a new application?
I would love to see some official documentation on how to do this.
We have a DTS package that imports data from a client's Excel file. Previously our client was using Excel 2000, but recently they upgraded to Office 2003, and now suddenly when I try to view the transformation task properties I get a Jet Database Engine error: "External table is not in the expected format".
Everything else with the file appears the same (layout, formatting, etc.).
I am new to the CE Edition. I am using Visual Studio 2003 and VB.NET.
I downloaded all the components to install SQL Server CE. I am running on Windows Media Center and have IIS working OK as I can do ASP.NET and connect to the localhost. I have Visual Studio.NET 2003 and the IIS. I also applied service pack 4 to SQL Server 2000 which is also running and working properly on my local machine. In other words, all the components are on one PC.
After the download, I then navigate to and run Sqlcesql2ksp2.exe and get the following message:
SQL Server CE Tools is compatible only with SQL Server 2000 SP1 and higher. When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000, ensure the installer for SQL Server CE Server Tools corresponds to the version of SQL Server 2000.
Can anyone help and tell me what I am doing wrong??
We have began to use Windows AUthentication for our SQL 2000 Server. When we llok atthe groups in AD we do not see any Domain Local groups? Is there a reason for that? Can I just add the group without browsing? I assume DLG will work with SQL for security.
