I have an application that is currently running against a 32-bit SQL Server 2005 Standard Edition database. For reasons I won't go into here, I need to move the database to a 64-bit SQL Server 2005 Standard edition running on 64-Bit Windows Server 2003 R2 Datacenter. Are there any migration issues I should be aware of in the Applicatio...
I'm trying to learn Actionscript 2 or 3, with AS2 I eventually figured by trial and error that I could get any named instance and modify it using a string with its name using var theinstance = "titletext"; // actually exctracted from an array _root[theinstance].htmlText = "New text with <b>HTML!</b>"; but when trying to convert the co...
Hi, I have a fairly huge database with a master table with a single column GUID (custom GUID like algorithm) as primary key, and 8 child tables that have foreign key relationships with this GUID column. All the tables have approximately 3-8 million records. None of these tables have any BLOB/CLOB/TEXT or any other fancy data types j...
I'm converting some Actionscript code from AS2 tp AS3, and I've eventually managed to get most of it to work again (it's allmost a totally different language, sharing just a little syntax similarity). One of the last things that still doesn't work, is the code for loading an external image. Perhaps this has changed in AS3 but I really t...
We have a large MS Access project that requires GUI functionality that is difficult / impossible to do in the VBA / access forms environment. Over time, we wish to re-write / migrate to a managed C# environment with WPF as the presentation layer. The only practical way for us to do this is over a longer period of time - converting som...
Wich is the best way to prepare a team for migration from svn to mercurial? Wich problems may appear in the migration? How to solve them? ...
Where can I download the rails migration file for country, state and city table ...
There is a SqlServer2000 Database we have to update during weekend. It's size is almost 10G. The updates range from Schema changes, primary keys updates to some Million Records updated, corrected or Inserted. The weekend is hardly enough for the job. We set up a dedicated server for the job, turned the Database SINGLE_USER made any ...
Given a table X and a view Y (that has the same structure as X) is there a way to rename X to Z and Y to X atomically so that no query will ever see nothing named X? Renaming X and creating the view would also be valid. The point would be to, as part of a schema migration plan, replace the old tables with views that simulate the old ver...
Hey, I have a mysql database filled up and running on a windows computer, is there any tool to transfer the database to another computer (running ubuntu)? Else I'll just write a script to take all the data base into SQL and insert it on the other computer. Just trying to save some time :) Thank you all. ...
Hi, how do you go about migrating your (large, important, well-tested) application to a new Linux distribution? Did you do so recently, if so, how did you overcome the problems of large numbers of upgraded components with changed behaviour? How did your build system cope with the overlap when you had to support old and new version? Did ...
One of our clients is upgrading their servers because the old machines can't handle the load of the database anymore. They have been using sql 2000 for the last 6 years and the db has grown to hold a few GB of data. Will it be worth upgrading to 2005 or 2008? What are the major benefits of the new versions compared to 2000? ...
Hi All, Pls, could you help me on the following issues: I would like to migrate from oracle to mysql and one of important step is to replace the actual job built on oracle environment; Basically every day I receive from other oracle environment some 'oracle' dump files (mainly CTL or oracle table exports). Today my oracle jobs load the...
I'm migrating a website made in classic asp to asp.net, but the asp.net dev server doesn't handle .asp pages. Is it possible to make it run .asp pages? Maybe a custom httphandler for .asp? thanks! ...
Which method makes the most sense for importing a module in python that is version specific? My use case is that I'm writing code that will be deployed into a python 2.3 environment and in a few months be upgraded to python 2.5. This: if sys.version_info[:2] >= (2, 5): from string import Template else: from our.compat.string imp...
Do any .NET frameworks allow you to create Business Entities first then Database. In other words allow you to use DDD / Persistence Ignorance method of backing into the database later. Any tools that allow the Models/Classes you have written to generate the SQL DDL and migration scripts. Feel free to rework my verbiage, and make it a be...
In this question superwiren asks about the pitfalls for converting a .net 2.0 solution to .net 3.5. What about .net 1.1 to .net 2.0? Is 2.0 fully backwards compatible with 1.1? ...
My team is working on a project to migrate a .com site into SharePoint. After all our look and feel assets, master pages, content types, and page layouts are created, we need to actually "move" the actual site pages into SharePoint. I'm trying to come up with the most effective way to do this. Our topology consists of an Authoring an...
I have some questions about customers about NF mode for DB2. Google had very little information about it. I've been able to infer the following but I don't completely trust it... NF and CM (compatibility mode) are settings on DB2 v8 on mainframe. DB2 v8 on z/OS in CM is designed to allow DB2 v8 to be used as a drop in replacement for...
If I'm adding a column via MySQL, I can specify where in the table that column will be using the AFTER modifier. But if I do the add_column via a Rails migration, the column will be created at the end of the table. Is there any functionality for rails migrations to specify the position of an added column? ...