Hi, As 64 bits support is not expected in the next version it is no longer an option to wait for the possibility to migrate our existing code base to unicode and 64-bit in one go. However it would be nice if we could already prepare our code for 64-bit when doing our unicode translation. This will minimize impact in the event it will fin...
I do my Rails dev from xterm and in vim. I'm getting sick of running script/generate migration do_whatever, then trawling through db/migrate trying to tab-complete to 20091015235018_do_whatever when there's 5 other migrations with similar timestamps. What's the best way to add a hook to open the generated migration in vim? I'd rather ...
I need to use the nifty_scaffold to generate all the views and controller for my model, but I already have the model, the migration and the table in database, so I don't need it to generate the migrations. The problem is that when it founds an old migration, it says Another migration is already named your_table: db/migrate/2009090421220...
Hi, I'm trying to create a rails app, but somethings going wrong, I'm getting a nasty error undefined method title' for #` I've used this ling: ruby script/generate scaffold Blog title:String body:text to generate the following migration file: class CreateBlogs < ActiveRecord::Migration def self.up create_table :blogs do |t| ...
I have some existing ASP.NET applications that are connected to Oracle 10g DBs and the applications vary from simple forms to complicated work flows with hundreds to thousands of DB entries ( applications are developed using Visual Studio 2003 and 2005) I would like to know the key pointers to consider when trying to migrate from this e...
I was wondering if the following migration is possible with Django south and still retain data. Before: I currently have two apps, one called tv, one called movies, each with a VideoFile model (simplified here): tv/models.py: class VideoFile(models.Model): show = models.ForeignKey(Show, blank=True, null=True) name = models.Ch...
Hi I'm looking to refine my workflow around NHibernate and a relatively frequently changing schema, and how best to deal with this - I would like the same solution to apply to production systems, so I think I need a migration engine rather than just Schema Update. What I want to know is how i can refine the workflow as far as possible s...
I need to migrate our SharePoint farm to a new domain. Until everything is moved we have full trust set up between the domains. Farm Hardware One WFE/Index Server Two SQL DB Servers (clustered) I know how to do this using all new hardware from production to a dev environment but doing an in place migration seems more daunting. To...
I have a 20-year-old project that I would like to migrate from RCS to git, without losing the history. All web pages suggest that the One True Path is through CVS. But after an hour of Googling and trying different scripts, I have yet to find anything that successfully converts my RCS project tree to CVS. I'm hoping the good people at...
In PHP Doctrine, is it possible to create one migration class that creates a table and creates a foreign key on that table? For some reason, I can't get the foreign key to work ... class Migration_001 extends Doctrine_Migration_Base { public function up() { $this->createTable('table_name', array(...)) $this->createFo...
Issue: Using the detach/attach SQL database from a SQL 2000 SP4 instance to a much beefier SQL 2005 SP2 server. Run reindex, reorganize and update statistics a couple of times, but without any success. Queries on SQL 2000 took about 1-2 sec. to complete, now the same queries take 2-3 min on the SQL 2005 (and even 2008 - tested it there...
I have the following migration and I want to be able to check if the current database related to the environment is a mysql database. If it's mysql then I want to execute the SQL that is specific to the database. How do I go about this? class AddUsersFb < ActiveRecord::Migration def self.up add_column :users, :fb_user_id, :int...
I would like to append the contents from one sqlite file (that has been created using Core Data with a Model A) to another sqlite store that is used by my application (which uses the same Model A). The idea is to quickly import large amounts of data. The problem I am facing is that the code below only works once. When I try to run the ...
I am migrating the excel sheet which has different data types using ssis But data format is changing in source level itself My excel sheet looks like below: COL1 Null 1/1/2009 Null 1/2/2009 11.99 123.99 When i see in the source preview it self i am seeing data like COL1 Null 1/1/2009 12:00:00 AM Null 1/2/2009 12:00:00 AM 12/30/18...
Just curious what the experience has been in uploading MS Access tables to SharePoint 2007 list. We've been planning on doing so, but I seem to recall issues with SharePoint mangling Access tables in the resulting lists and generally the migrations not going so well. Your experiences? Best practices and recommendations? I'm particular...
OK long story short, we designed and built a web application connecting to a standalone SQL Server 2000 database using asp:SqlDataSource and System.Data.SqlClient, now we are looking at migrating to a db2 cluster. Aside from the connection string, do we need to do anything on the web application? I am clueless about DB2. We have close to...
I was doing this kind of thing in my migrations: add_column :statuses, :hold_reason, :string rescue puts "column already added" but it turns out that, while this works for SQLite, it does not work for PostgreSQL. It seems like if the add_column blows up, even if the Exception is caught, the transaction is dead and so the Migration can...
Hello Everyone, We've planned to move from Visual SourceSafe to TFS. For this purpose, we brought a new server machine with updated specs and TFS installed. The Visual SourceSafe machine still has its use in the environment as the TFS machine dedicated for a single project. All the projects are there in Visual SourceSafe machine and ar...
Migrated a MOSS content DB to a brand new farm. The My Sites also were on the same content DB. Then the SSP also was migrated over. However, the My Profile link is not binding to the restored My Sites but rather to the old MOSS server. Anyone know of any solutions? ...
I want to migrate schema from Oracle to MySQl, so are the any free tools that would be useful for this task ? I have only Create tables in Oracle SQL Script but it contains unique constraints, foreign key and MySQL has MyISAM storage engine and so foreign key is not supported, how to go about this issue ? Sample Oracle create statments...