Hi there, I am trying to run a migration on an existing database to change the column name on a table. When I run the migration, I get an error stating that Blob/Text fields cannot have a default value. The column in question is a text column, with a non-null attribute, but no default value. The migration that Rails attempts is: ALTE...
Is it possible to transfer a repository from CVS to SVN one branch/tag at a time? Because each branch is currently a different project, I would like to be able to transfer the branches one at a time (when there is little activity on a specific branch). Eventually the branches will all exist in the same svn repository. ...
This problem is basically the same as the previous question here. However, the answer there does not work for me. I've installed the trunk version of south, manually entered the import line in the migration file in question, and done a full 'startmigration' in a separate directory and examined the 0001_initial.py file. I have a Django ...
Hi all I have a bunch of performance counter logs setup on a Windows 2000 machine that I would like to move lock, stock and barrel to a Win 2003 machine on the same network. I can't see a way to export that details of all the perf logs and import them, so any ideas on where to look under C:\WINNT for the raw perf log configurations wo...
This must be something simple but it's driving me nuts! I have a migration where I want to update a record afterward class SubjectsTextField < ActiveRecord::Migration def self.up add_column :users, :subjects, :text User.find(39).update_attribute :subjects, "hey there" end def self.down remove_column :users, :subjects...
I'm a linux noob wanting to migrate this piece of C# code: using System; using System.IO; using System.IO.Ports; public class LoadCell { private static string configFile = Directory.GetCurrentDirectory() + "\\LoadCell.config"; private static string errorLog = Directory.GetCurrentDirectory() + "\\LoadCell.log"; private stati...
Within a SubSonic migration this code: public override void Up() { TableSchema.Table test = CreateTableWithKey("test"); AddSubSonicStateColumns(test); base.Up(); } generates the following ddl for MySQL: CREATE TABLE `test` ( `id` INTEGER NOT NULL AUTO_INCREMENT, `CreatedOn` datetime , `Modif...
my sql DB contains tables "jobs" and "job_categories." "job_categories" associates job category strings (i.e. "Software Development") with an integer number (i.e. 7). I need these associations saved into variables in my job controller for various query functions. How can I use rails to dynamically link changes to the job_categories tab...
The EJB3 spec indicates that EJB2 and EJB3 can co-exist in a single application. I wish to migrate my EJB2 stateless session beans to EJB3 stateless session beans. This question does not relate to JPA at all (that is a separate piece of work to be carried out in the future) I'm running on websphere 6.1 with the EJB3 feature pack instal...
I've been put in charge of migrating a customer's website of MS SQL/ASP to PHP/MYSQL. I have zero experience with MS SQL. I'm trying to figure out the best way to get the current data migrated to MySQL so I can begin PHP development. Some details: I downloaded SQL Server Mangement Studio Express. I found the following string in...
Hello all, I had a project for developing a website for a NGO. I had a doubt: The website is already working with lot of flaws and had very few pages. This website is made in Php and They want me to make it more secure. So i want to make this website using Microsoft .NET Framework. If i make this website from scratch and then...
Hi folks, i'm trying to migrate some data from two tables in an OLD database, to a NEW database. The problem is that I wish to generate new Primary Key's in the new database, for the first table that is getting imported. That's simple. But the 2nd table in the old database has a foreign key dependency on the first table. So when I wan...
(no responses from my identical post on the MySQL forums, so I'm hoping to have better luck here) I'm trying to migrate a MS SQL database for a friend. I do not have physical access to the machine, nor do I have admin access -- just a read/write user. Using "SQL Server Management Express" in XP, I can easily login using IP/user/passwor...
I'm researching a potential move from SourceSafe to Subversion and we are struggling with the edit/merge/commit vs. checkout/update/checkin paradigm. The primary concern is how do you know which files are checked out with Subversion (and to whom)? Is there a Subversion equivalent to "Status Search" in VSS? Or is it not possible beca...
Google does not really deliver much content (or my query sucks). Has anyone made the switch and can share the experience? ...
Does rake db:migrate only add new migrations, or does it drop all migrations/changes and build everything new? I think rake is throwing an error because it is trying to access a table attribute in migration 040 that was deleted in migration 042. somehow my DB and rake are out of synch and I want to fix them. for you experts out there -...
i have a bug in a "self.drop" in a migration such that I cannot roll back past that migration. how can i start from scratch and build up from migration 001? also, is there a way to do this without losing my data (it's just testing, but still...) ...
What are best practices for migration management? For instance, when debugging a migration, do you edit the original migration or add an edit migration before committing to the repository? Thanks! ...
I've tried the following but this seems to only create an empty migration file: startmigration appname freeze_appname --freeze appname i've also tried just: startmigration --freeze appname doesn't work either. ...
i'm using Netbeans 6.5 for RoR development. I believe my sqlite3 DB is out of synch with rails migrations. how can I view and manipulate the database (through netbeans or command line)? ...