so I have an old database that I'm migrating to a new one. The new one has a slightly different but mostly-compatible schema. Additionally, I want to renumber all tables from zero. Currently I have been using a tool I wrote that manually retrieves the old record, inserts it into the new database, and updates a v2 ID field in the old ...
A while ago we started developing a new project which internally has about 25-30 different classes/types/models that are heavily related to each other either via 1:n, n:m or n:1 relationships. Back then we went with a native .net oodbms system basically because what it allowed us to do was to take our object model and simply add a few p...
I have a legacy web application php4/mysql4 (MyISAM, db contains some cms, some user data, some calendar application). Now I am going to migrate to a new server with php5/mysql5. What are the typical php issues in such a migration scenary (php, sql queries, anything)? I've heard that the function parameter passing changed, call-by-refe...
I have seen a lot of talk regarding ActiveRecord Migrations and whether or not they should be used to change data within your application, some people saying yes some saying no. My question is if you are not using Migrations to do this then what are you using? Just another script that you write? I am after suggestitions on alternative w...
Is there an easy way to run a single migration? I don't want to migrate to a certain version I just want to run a specific one. ...
Hello, I want to run two rails websites (homepage and app) on the same database. However, migrations dont work because both websites try to use schema_migrations table at the same time. Is it possible to override default schema_migrations table name? Any other ideas how to solve this problem? ...
Hello, Probably I'm doing something wrong but here it goes: I'm trying to create a database using subsonic.migrations in an OracleXE version 10.2.0.1.0. I have ODP v 10.2.0.2.20 installed. This is my app.config: <?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> <section name="SubSonicService" type="SubSon...
There are some tool (free preferentially) to to migrate data between different DBMS (like from MySql to Firebird, or Sql Server to Sqlite, etc)? Edit: I want specifically to migrate from "Firebird Embed" to "Sqlite". But in another situations (like migration of my customers websites) I need migrate from MySql to Sql Server (and vice-ver...
I am writing a private messaging system for my web app. Just think of it as doing the same thing as sending PMs on your typical social networking website like Facebook or Twitter, or even sending an e-mail through Hotmail. I have come up with the following migration so far: class CreateMessages < ActiveRecord::Migration def self.up ...
Hello, I have a local server where I do all my testing and work. Once I am done, I simply upload the db schema along with the relevant code. However the problem arises when I make some changes to the schema. I have to manually type the "alter table" query on my live server. Is there a way to get the incremental changes that took place...
I have secured the budget to upgrade the individual workstations and latops. While newer, bigger screens were welcomed with enthusiasm, the thought of re-installation tools and settings caused most of them to blanch and I got one "Do I really have to?". How much downtime do you usually have when you move to a new machine? Do you employ...
How do i migrate my data from VSS to SubVersion?? ...
I am contemplating a switch from MySQL to PostgreSQL. What are your tips, tricks and gotchas for working with PostgreSQL? What should a MySQLer look out for? See also: How different is PostgreSQL to MySQL? See also: Migrate from MySQL to PostgreSQL Note - I don't think this is a duplicate. In particular the type of answers are ...
Before I get pointed to one of those 'VS.' questions like below... ASP.NET webforms + ASP.NET Ajax versus ASP.NET MVC and Ajax framework freedom Should I pursue ASP.NET WebForms or ASP.NET MVC ASP.NET MVC Web application vs ASP.NET Web Application ... please let me state that I'm not looking for a comparison. Some of my concerns tha...
I'm designing a web application for a team that is currently tracking all of their data in a Microsoft Access database. The new database will be stored in mySQL, but I don't know enough about Microsoft Access to be certain that I'm doing things correctly. Is there a tool or procedure that exists that will quickly create all the proper t...
I'm new to FDT and I'd like to move some (actionscript)projects from FlexBuilder to FDT. I've noticed FDT can read .actionscriptProperties from FlexBuilder, so just setting the workspace to my FlexBuilder workspace got the projects, the current one open, the rest of them closed which is great. I got a an error on the way: "Error openi...
As I've mentioned in a previous question, I'm looking into migrating our source control from Perforce to git. Looking around, I've found p4-git (you have to dig a bit more, since it's not even at the repository pointed by the link. The actual p4-git script harder to find). I'm now running this script, and it imports the current versio...
I need to migrate a .net solution from 1.1 to 3.5. The solution currently contains 2 CS projects 1) a Class Library and 2) a Web Service application. Problem: I need to migrate the solution file and the Web Service application project, however I cannot migrate the Class Library as it is shared with another solution that will not be mig...
Hi, our client wants to change from Sharepoint 2.0 to 3.0. Of course they need all documents to be migrated too. I have some experience with 3.0 -> 3.0 migration, but that's all. Main requirements are: Document export from 2.0, import to 3.0 Migrate attributes too (CreateDate etc.) Bulk mode Thanx in advance! ...
Hello everybody ! Is it possible to add behaviors (eg. actAs Timestampable) in a doctrine migration to avoid defining the created_at and updated_at columns ? Thank's in advance ! ...