Migrating Shape Sql To Something Equally Powerful?
Mar 7, 2010
we are currently investigating a migration of an application that doesn't meet company standards. The application is built using VB6 and Shape SQL/Access. The application has about 120 reports by storing Shape SQL strings in a database which the user can modify using a wizard. Shape sql is not allowed at this company. We have investigated plain SQL, Linq, Entity Framework as alternatives... but all result in more complex solutions.
Update: Shape SQL is an ADO command to get hierarchical datasets, for further info:
I'm currently programming an application in ASP.net MVC and I'm looking for a plug-in or anything that will to draw some rectangles and manage them. The rectangles should be resizable, movable and they should be compose of 8 points (at the middle of each corner and at each corner). I already found SVG, HTML 5(canvas) and [URL].
I need to develop a new functionnality for one of our application.
Basically, what i want to develop is a way to let the user draw a semi-transparent rectangle over a static image. The principle could be the same as mspaint. The user click on a button a then, can draw his rectangle over an image.
I have problem with a stored procedure and function that return the same shape, but as they are different methods LINQ won' t let me cast between the two. Please see code for the two SPROCs below (This is actually simplified to represent the problem, so please don't spend lots of time explaining alternative ways of writing the function/sproc.)
Table Valued Function "getCategories()" SELECT categoryName, categoryID FROM categories SPROC "getUnusedCategories" SELECT categoryName, categoryID FROM CategoryInstances cI FROM dbo.SMAN_getCategories(@SiteMANID, @SectionID) c LEFT JOIN @EntityResultsTable er
Okay so my situation at work is that I've written about 200 or so lines of additional functionality into an aspx page's code-behind that is currently not to be implemented. It is in a subroutine that handles an event that currently has zero chance of occurring.
Because this code is not being used, I've gotten curious. Should I comment out the subroutine that has zero chance of firing? Would it do anything to enhance the performance of the page or anything like that if I did indeed comment it out? Or could/should I just leave it as is?
I'm getting close to finishing a public-facing ASP.Net app and I'm starting to weigh deployment options. I'm an ASP.Net/SQLServer veteran but noob when it comes to Azure. I'm wondering how others have felt about the learning curve to effectively migrate a local dev ASP.Net/SQLServer apps into Azure cloud. More specifically:How steep is the learning curve towards understanding administration and programming concepts, and do you think it's worth the investment?What is Microsoft's support like if I have catastrophic problems from my cloud infrastructure and my live site is down? My expectation is a large price tag for a not-so-urgent SLA.Will my non-Azure ASP.Net app require significant modification and/or coupling to run in the Azure environment?
We already have our vb.net project in asp.net1.1 framework now we are changing the framework to asp.net4.0.But we are facing more warnings like unused local variables and function need return statement.it exceeding maximum warnings because of these kind of issues.Is there any tool to remove unused local variables.
I have upgraded my web site from 2.0 to 3.5 using VS2008 (loaded the project and selected 'yes' to the upgrade prompt), then deployed to the Live server. On the test system the website runs fine, on the Live, it fails with 'Assembly binding' (System.Core, System.Web.Extensions, and more) errors. When I commented out all the failed assemblies (just to see what happens) I got the error: 'csc.exe' cannot be found. Can anyone tell me what is wrong? 1. Is my upgrade method wrong? 2. Is there another way to upgrade? 3. How can I tell why the assemblies fail to bind?
After migrating my app to .NET 4 it's not starting. When i'm trying to load it in browser it endlessly loading it and nothing else happening. There is no errors or timeouts, just loading.
some automated tools to help in migrating classic ASP to ASP.NET I tried to install "ASP to ASP.NET 1.x Migration Assistant" from the link below but it encountered a problem during installation. Has anyone used it? Any other better tools? I know everything cannot be automated but I would imagine there are some tools out there. [URL]
We are in design phase of a project whose goal is replatforming an ASP classic application to ASP.Net 4.0. The system needs to be entirely web based. There are several new requirements for the new system that make this a challenging project:
The system needs to be database independent. It must, at version 1.0, support MS SQL Server, Oracle, MySQL, Postgres and DB2. The system must be able to allow easy reporting from the database by third party reporting packages. The system must allow an administrative end user to create their own tables in the database through the web based interface. The system must allow an administrative end user to design/configure a user interface (web based) where they can select tables and fields in the system (either our system's core tables or their own custom tables created in #3) The system must allow an administrative end user to create and maintain relationships between these custom created tables, and also between these tables and our system's core tables. The system must allow an administrative end user to create business rules that will enforce validation, show/hide UI elements, block certain actions based on the identity of specific users, specific user groups or privileges.
Essentially it's a system that has some core ticket tracking functionality, but allows the end user to extend the interface, business rules and the database. Is this possible to build in a .Net, Web based environment? If so, what do you think the level of effort would be to get this done? We are currently a 6 person shop, with 2.5 full time developers.
I am tryin to rebuild a website designed in asp.net.But,being an informative site it has a lot of content in it which i dnt want to input to the database manually.can ne1 help me out with any drupal module to migrate the asp.net data in sql server to mysql db in form of drupal architecture??say for example a page in asp.net is displaying data from a form.Can i migrate it in form of cck and get the page data as nodes table.
I know very little, and even less about .dll's. I have a fairly simple albeit old, application that references a .dll that seems to do the logic for connecting to an access backend. I don't have the source code for the dll, but I don't see any code anywhere elese to sigify the dataconnections etc. When I move the application from an old IIS6 server .net 1.0, over to a newer IIS7 server with .net 2.0osmething, I errors out (see below). When I remove the reference to the dll, the login pages comes up okay but I just can't login. So, something is up with my DLL. What do I need to do?
Error Information: Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission contact your system administrator or change the application's trust level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'failed. Source Error:
New functional requirements stipulate that what was once a one to many relationship is now a many to many relationship. The relationship comprises a simple lookup table
How does one manage the migration of data from the old structure to the new???
I have the following script which will move the data from/to the right tables:
[Code]....
What i'm wondering is, once i have run the script to copy the data across, do people recommend that the LegacyTable.LookUpPK_ID field be deleted permanently?
Recently I moved my developing environment (Visual Studio 2005) on Windows 7. I followed the steps for migrating from IIS6 to IIS7, but when I try to start debug my web project I receive the error message:
"Unable to start debugging on web server. Debugging failed because integrated Windows authentication is not enabled."
We have a few settings in our web application that can be user configured. As IIS exposes helpers for configuring "Connection Strings" and "Application Settings" we decided to take use this method of configuration.
Unfortunately this works by editing the Web.config file deployed in the web application. This means that a simple upgrade process of copying over the files from a newer web application release resets all configuration settings to the default.
Possible options:
When upgrading the webapp, backup the Web.config and restore it afterwards. This is not elegant and if the latest webapp defines new default-valued properties in the Web.config then this will break Write some admin-only configuration pages on the site and store the values in the DB. This puts the control back in our hands, but it will take work to write this and obviously has bootstrapping problems with connection strings.
I was working on migrating MVC1 app to MVC2 today and i have come across a problem while changing the ValidationMessage to ValidationMessageFor implementation.
I have a web project running fine with IIS 6, when I try to run this project in IIS 7 Integrated mode I am having all kind of problems with global.asax, it appears to me if any of the following objects or properties is access in Application_Start, exception will be thrown: HttpContext.Current.RequestHttpContext.Current.Reponse HttpContext.Current.Server.UrlEncode The exception will be something like:Response is not available in this context.I have no ideas why this happens. I am not even sure if it only happens in Application_Start since project could not execute. Also there might be more objects causing other problems that I haven't encountered yet.
I have a application in asp.net2.0 with C#. I have migrated my application in .NET 3.5 & I am receiving the below error.
Could not load file or assembly 'Microsoft.Build.Framework' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.
I have inherited a web application that uses tables to layout the whole web application. This is a rather large web application and I would like to migrate it to using divs for layout instead of the current birds nest of tables.Does anyone have any good suggestions for the best way to migrate the web site to using divs (That would convince the boss that it's worth doing).This is a asp.net web application where most of the html is done through response.write.EditI have been working with the site for a while now and would have to say that even a site with a badly nested div layout would be better than using table layout.
