I am trying to migrate data from SQL Server to mysql, and i'd like to do that using insert-statements, so i modified this nice script by Narayana Vyas Kondreddi to generate mysql-friendly code and everything works fine so far. the problem being columns of the TEXT datatype that can be more than 8000 characters long (containing long blo...
We need to keep a copy of our legacy data for reporting purposes but our previous vendor is requesting we delete all copies of the old DB. Deleting the data makes no sense, it a very real sense that data is ours, but we're not sure of 'normal' legal ownership of the schema. Does anyone have experience of a previous supplier requiring all...
I am trying to open my project (that is in ASP.Net 2.0 ) in VSTS 2008. Earlier i used VS 2005. When i try to build the project it gives me the error "Unable to create DiscoveryClientProtocol from reference map file"? I tried to figure out this error and found that there is some problem with web reference to the web service i am calling. ...
What technical issues am I likely to encounter when migrating a database from SQL Server 2000 to SQL Server 2005? Are there any common problems I should be aware of? Should i be worried about any T-SQL changes that may break when stored procs are executed against the newer version of the database? What about DTS packages? Are there any...
Are there any best / recommended practices when moving an existing BizTalk 2004 application to BizTalk 2009? BizTalk 2009 (and prior to that BizTalk 2006) introduced various significant improvements to core processing logic - everything related to error handling, for instance. During our migration process we would like to take the oppor...
Hello there! I'm searching for a tool to dump a database including DDL and content as plain SQL-SCript, so that in can be archived in plain text format. I know e.g. the Oracle dump tools or mysqldump, but is there a tool which can connect to different datasources and get the job done? GUI would be great. Thanks, Chris ...
Hi there! Can anyone please tell me how can I add a new column of type enum to my schema in order to implement a Doctrine Migration? Thanks in advance, Best regards! ...
Does anyone know an automated solution to migrate Oracle Forms to Java desktop forms (e.g. a code generator whose input are Oracle Forms definition files and output is Java code in AWT/Swing/SWT/whatever)? Preferrably open-source or free, but commercial ones are also a possibility. ...
I have a table that contains sales transaction (~20 mil rows). Previously I used SQL Server and export it to an Excel pivot. Data refresh took 10-15 minutes but still do-able. However, after I migrated to MySQL (using XamppLite & ODBC), it took forever to refresh the data in the Excel pivot. Maybe I didn't optimize the MySQL good enough...
Hi there, currently I'm faced with a LOT of static HTML documents to convert to SharePoint (MOSS 2007), basically they can remain static, but need to be migrated into the SharePoint site with the SharePoint look and feel (each page needs to be updated with the SharePoint headers and footers at a minimum), are there any tools out there th...
I'd like to convert a repository from Subversion to Mercurial, but when I initially set up the repository, I did it in the laziest way possible. Over time, the structure continued to morph and deteriorate (it's 5 years old at this point). Nevertheless, I'd like to preserve as much history as possible, even if I have to get dirty and ma...
Hi, There are at least two Grails plugins that emulate the database migration functionality of Rails. Autobase Liquibase Is there a consensus about which of these is best, or is there another plugin that does database migration which is better than either of the above? Thanks, Don ...
Hi, I am to migrate a Websphere machine (including the applications which run on it) to a new machine. They wanted a clean install of the OS and WebSphere, so I did that. I also took a full file backup of all of the applications they had on the old server. The problem is that to re-install them on the new server, the WebSphere dialog...
I'm getting an error when running db:setup for my Hobo project with a clean database. I have two models, A and B, where B extends A through single-table-inheritance. Creating everything works. But if I start with a fresh database, rake fails with an error: $ rake db:setup ... rake aborted! Table as does not exist Here are the steps I ...
Currently we use SQL Server and we have A LOT (read around 5.000) different scripts that create on the fly temporary tables. Now we are migrating to ORACLE, so we cannot create on the fly temporary tables. Any ideas? Thanks in advance ...
I have been researching a way to get the SQL statements that are built by a generated Migration file. These extend Doctrine_Migration_Base. Essentially I would like to save the SQL as change scripts. The execution path leads me to Doctrine_Export which has methods that build the SQL statement and executes them. I have found no way of ...
I'm working in an Access 2007 database and need help migrating tables to SQL server. Is this possible to do having only purchased Access 2007 or do I need to download a separate program for SQL? When I try to create a new SQL database or open an existing one through Access, I'm getting a "CREATE DATABASE" or "CREATE TABLE" error and not ...
So I've a user model and a corresponding table (users) with fields: User_id, username, password etc. But then I added invitation_limit to users table. Newly created users have invitation_limit, however the users created before the invitation_token migration was run don't have the invitation_limit field. How do I update the previously c...
There has been a tremendous amount of research on migrating Java threads between different JVMs on different machines, but is there some publicly available, maintained, de facto implementation that everyone uses? If there is not one good implementation, but multiple ones, which one do you guys recommend and why? (Note: I'm not talking ...
I have followed Ryan Bates tutorial on nested models. Several of my nested models have dates associated with them. In my migrations, they are actually the type "Date." Some things I have tried and problems I've run into date_select - can handle the form object prefix, but not nested models attributes select_year - doesn't work wit...