I'm converting a db from postgres to mysql. Since i cannot find a tool that does the trick itself, i'm going to convert all postgres sequences to autoincrement ids in mysql with autoincrement value. So, how can i list all sequences in a Postgres DB (8.1 version) with information about the table in which it's used, the next value etc w...
Hi, I was asked to provide an estimation to change a relatively small app designed with MS Access to use a SQL database. First, is this even possible? I never worked enough with Access, so I'd like to know. If it's possible can you please point me to some websites with tutorials regarding this? Second: if it's possible, is it recommen...
Is there anyone out there whose company has migrated from a medium to large Subversion repository to Git? If so: What were the pitfalls you had to overcome? How easy was it for your developers to make the switch and learn Git? Is it a good idea for companies to migrate at this point or should they wait for Git to become more mature (e....
Hi, I am migrating my js lib from prototype to jquery. However, I don't know how to replace the following code: var utilityMethods = { autoHide : function(element) { //... } Element.addMethods('SPAN', utilityMethods); Is there a jQuery equivalent for extending the DOM? Thanks ...
I have the folowing migration but don't know what to use in the down method change_table :addresses do |t| t.references :addressable, :polymorphic => true end ...
I've got a very simple migration that adds a single boolean column: class AddMuteToPreferences < ActiveRecord::Migration def self.up add_column :preferences, :mute_audio, :boolean, :default => false end def self.down remove_column :preferences, :mute_audio end end I run the migration: == 81 AddMuteToPreferences: migr...
I have code in an svn repository, call it repository A. Now say that I need to move the contents to repository B, but repository B has already been active for a while for other projects. Is it possible to move a particular directory from repository A to repository B, preserving the file history? Normally, to migrate an entire repository ...
Why does the ruby on rails migration syntax look like this: create_table :my_table do |t| t.integer :col t.integer :col2 t.integer :col3 end And not: create_table :my_table do integer :col integer :col2 integer :col3 end Personally I find the second snippet much more readable, are there any reasons w...
I have been researching this a wee bit and it seems to boil down to: 'Eyeball Mark 1' The best tip seems to be the use of SuperPreview from Microsoft's Expression team. If anyone has automated a way to go about this I would love to hear about it. Also, I believe that SuperPreview requires a work around for a password protected app to...
If I have a has_many and belongs_to relationship between Questions and Answers: class Question < ActiveRecord::Base has_many :answers end class Answer < ActiveRecord::Base belongs_to :question end Do I also need to modify the migration files to use "references": class CreateAnswers < ActiveRecord::Migration def self.up cre...
We have the standard 3 environment setup of development, testing and production. Each environment has their own report server, web server, database server, etc. Part of our migration is to move our business objects (xi r2) reports between the servers but as of right now we need to manually update the connection settings for each report...
I'm tasked with doing a SQL Server 2000 to 2005 migration. I will be doing a side-by-side migration. After restoring from a backup I plan to do the following: ALTER DATABASE <database_name> SET COMPATIBILITY_LEVEL = 90; DBCC CHECKDB(<database_name>) WITH NO_INFOMSGS DBCC UPDATEUSAGE(<database_name>) WITH NO_INFOMSGS exec sp_updatest...
Hi SOers, I found very much about the benefits of using a newer .Net version for programmers (LINQ, WPF etc.) but I didn't find anything about the benefits for our customers. So, I'm thinking about migrating our application (WinForms, C#, .Net2.0) from .Net2.0 to .Net3.5 and I need answers to the question: "What are the benefits for ou...
I want a migration to create a clone of an existing table by just suffixing the name, including all the indexes from the original table. So there's a "snapshots" table and I want to create "snapshots_temp" as an exact copy of the table (not the data, just the table schema, but including the indexes). I could just copy and paste the b...
Does anybody know anything about using Migration Workbench to migrate db2 database to oracle 10G? I am getting a strange SQL1402N error when I try to get source capture. ...
I have an iPhone app that uses Core Data. I did an update and used Lightweight Migration to go from V1 to V2 of my MOM (Managed Object Model). This worked perfectly. What happens when I want to go to V3 (and beyond) of my MOM? If I decide to continue with Lightweight Migration, will it automatically deal with migrating from V1 to V3...
I'm encountering a very annoying error using Core Data on Mac OS X 10.5. All entities have classes in my application which share the same names. Up to this point, I've done 5 migrations without problems. I'm using the XML data store. I've got V5 of my data model with 13 entities, 4 of which are abstract. It looks like this: What I d...
I'm testing my app out on Heroku (which is f***ing amazing!) and I realized that I have no way of creating my root user. I'm using Authlogic and rails_authorization_plugin. Is there someway I can add a section to one of my migration files to add this user and assign it the role of root? Or can I do this through a rake task? Any insigh...
I was asked to choose an open-source alternative to Clearcase-UCM, and I need an advice what would be the best match. Given below are some parameters I've collected: Half of the development teams use the Integration view, development view, rebase and delivery methodology. The rest just work straight on their integration stream with pri...
I'm looking at what is needed to move from wordpress.com to a BlogEngine.NET or similar blog. I've seen a tool for replacing export.php so that it will export your wordpress site in BlogML format so it can easily be imported into BlogEngine.NET, however I'd really not want to have to setup php/wordpress just so I can import a back up fro...