If you have already been prompted to migrate your solution from .NET 2.0 to .NET 3.5 and you responded "No" at the time, how do you get Visual Studio 2008 to re-prompt you with this question? Sorry, if there is a real simple solution to this one. ...
I'm trying to test a plugin that i wrote by running: rake spec:plugins When i execute this command it appears that it drops my database tables (in my test DB) and then runs a migration without any plugins loaded to give me a clean database. This would normally be fine, but I am using a plugin that allows me to set index length limits ...
I want a Customer to reference two Address models, one for the billing address and one for the shipping address. As I understand it, the foreign key is determined by its name, as _id. Obviously I can't name two rows address_id (to reference the Address table). How would I do this? create_table :customers do |t| t.integer :address_i...
Hey all - I have a model in my Rails app that uses the :class_name attribute for has_one: class Foo < ActiveRecord:Base has_one :main_bar, :class_name => "Bar" # ... end I'm a bit unsure what to put in the migration for this class now. Can I use references? What will Rails be looking for as the column name for :main_bar? Can I d...
For performance reasons, i want to set the Indexed Attribute to some of my entities. I created a new core data model version to perform the changes. Core Data detects the changes and migrates my model to the new version, however, NO INDEXES ARE GENERATED. If I recreate the database from scratch, the indexes are there. I checked with SQ...
Recently I've been trying to restructure an old database that was not designed with filegroups (just the default PRIMARY) and, among other things, move a bunch of tables to a new Data filegroup residing on a SAN. I know how to migrate the data: ALTER TABLE MyTable DROP CONSTRAINT PK_MyTable WITH (MOVE TO [MyDB_Data]) ALTER TABLE MyTab...
I'm writing a migration to convert a non-rails app into the right format for rails - one of the tables for some reason does not have auto increment set on the id column. Is there a quick way to turn it on while in a migration, maybe with #change_column or something? ...
Hi! If there any manual or article on how use CakeShema? I'm interested in using models & using bare sql in before() and after() methods. ...
An old one of my ruby on rails migrations contains both the actual migration but also an action to modify data: class AddTypeFlagToGroup < ActiveRecord::Migration def self.up add_column :groups, :selection_type, :string Group.reset_column_information Group.transaction do Group.all.each do |group| group.selection...
I created my own SVN repo locally. Then used: svnsync init DEST SRC svnsync sync DEST svnsync checkout DEST The checkout worked successfully and I got all the files from the original SVN repo and that is definitely a good thing! But when I did: svn log All I get is the message: svn: Item is not readable Does the file not have a...
I'm considering undertaking a project to migrate a very large MS Access application to a new system based on SQL Server. The existing system is essentially an ERP application with a couple of dozen users, all sharing the Access database over the network. The database has around 300 tables and lots of messy VBA code. This system is beginn...
I have a Rails project and I used Migrations to setup the database schema (I'm using sqlite3). I have a XML file that I want to insert into my database. What's the best way to approach this? I'm thinking there's some Ruby script that I can write once and use to parse the XML file and insert it into my database, but intuitively it feels l...
The following databases exist for each internally and independently developed software (web-based or client-server) application for a company: Development (D1 and D2) Integration Staging Testing Production The Production environment is shared between applications. Migrating applications requires: Run a script that changes the Prod...
What will be broken after migrate to MVC 2? I wonder what breaking changes will come with MVC 2, so how traumatic will be the migration? How much smooth have been your experience migrating? ...
I am developing Infopath forms (not web-enabled) based on webservices that I host locally on my development machine. when the form and webservice is ready to deploy to a test/QA/Production server I have to go into the form and modify the data connections each and every time I have to point it to the relevant webservices, depending on th...
What is the vantage of asp.net mvc? How can I migrate from asp.net to asp.net mvc? ...
So this is my first real Ruby on Rails project. I've learned my lesson -- I didn't make all changes using migrations so things are a bit messed up. What's the best way to start over with new migration files and rebuild the schema, etc? My project is too far along to rebuild the entire project, but not far enough along to where I care ab...
I'm converting the infrastructure at my workplace to use git instead of svn. The overall migration is going well, but we have a tool that I developed to do our SQL schema migrations. In order to deal with individual schema change dependencies, the migrations script used subversion keyword replacement to put the last-changed revision nu...
We are porting a Classic ASP app to ASP.NET. What do we do about the #INCLUDE (.inc) files? Now they're causing build errors because ASP.NET thinks the variables are "not declared". ...
Im working on a patch for an open source project that uses svn. I dont have commit access but I want to version track my own changes. I followed this guide to read and convert the svn repos into a hg one. I want to be able to pull new changes from the official svn repos into my own local copy, how can that be achieved? After the import...