Hi all, At my work we are currently having some serious pains pushing our database changes across environments. The issue starts to show up when we create a new non-nullable column on an existing table. The script that SQL Compare generates creates the column as non-nullable, so it will always fail. I was hoping that there was some al...
Does anyone have experience with companies that have migrated from classic Asp to .Net badly? In this company, the "folder" icon that represents a Solution and the "folder" icon that represents a Project and the "folder" icon that represents a file directory are all the same thing. The .Net IDE is just a better notepad. The entire com...
This is kind of a follow up to this question: http://stackoverflow.com/questions/849897/can-rails-migrations-be-used-to-convert-data If I'm working on a branch that, when it is re-integrated and released to production, will change the database schema quite drastically. What is the best way of ensuring that all the data in production get...
If I had the following table. create_table :my_table, :id => false do |t| t.string :key_column t.string :value_column end How would I ensure that the rows are optimaly stored for binary search by the field of :key? And how would I make sure binary search is used? ...
I hate writing migrations, but it's important for the schemas to stay in sync. What I'd much rather do is update my schema.rb and have Rails notice, then run something which generates the appropriate migration based on the difference between the old version and the current version. Is there a way I can do that? ...
I am trying to load a swf written in AS2 into an AS3 swf - using Loader class and listening for Event.COMPLETE. in my onCompleteHandler function i want to add this to the stage so Im trying - addChild(evt.currentTarget.content) ... but I get the following error message: Error #2180: It is illegal to move AVM1 content (AS1 or AS2) to...
Good Day, We have migrated our web application to ASP.NET 2.0 from ASP.NET 1.1. We have a page that contains a couple of textboxes with their respective Validators. On .NET 1.1, when a textbox contains an INVALID value, clicking on the "submit" button, will not produce a postback (E.G. Nothing will happen). However, when we migrated ...
Downloading it now and was wondering if anyone else has moved an existing Custom process template (Work Items types, work items and source control) to the beta. Over the past few years our custom process template has "evolved" and I know it has unused fields in it. Do you think if I set up another server added our custom process templat...
I was watching a screencast where the author said it is not good to have a primary key on a join table but didn't explain why. The join table in the example had two columns defined in a Rails migration and the author added an index to each of the columns but no primary key. Why is it not good to have a primary key in this example? c...
Let's say I create a table in a Rails migration, specifying to omit the ID column: create_table :categories_posts, :id => false do |t| t.column :category_id, :integer, :null => false t.column :post_id, :integer, :null => false end Later I decide I want to add an ID column as a primary key so I create a new migration: class Change...
Hi all, I am getting this error when running "./manage.py migrate app_name" While loading migration 'whatever.0001_initial': Traceback (most recent call last): File "manage.py", line 14, in <module> execute_manager(settings) ...tons of other stuff.. raise KeyError("The model '%s' from the app '%s' is not available in this migrat...
I have existing flash 8 AS2 work that I want to update to Flash 10. Can I update only those elements i need to be Flash 10 and load them in to the Flash 8 movie as an external swf and pass variables and call methods? Is this a good option and what are the issues to be aware of? Eg will a user with player lower than 10 be able to load the...
I created number of migrations starting with a definition for a Posts table. class CreatePosts < ActiveRecord::Migration def self.up create_table :posts do |t| t.column "title", :string, :limit => 100, :default => "", :null => false t.column "content", :text, :null => false t.column "author", :string, :limit =>...
rake db:schema:dump This command gives you the schema of a legacy database and you can build a migration for that database off the generated schema. But if that database had data in it, it would be nice if there was a rake command to retrieve the data in a migration file generated by Rails. Perhaps I'm dreaming - it's probably aski...
MySQL has a RENAME TABLE statemnt that will allow you to change the name of a table. The manual mentions The rename operation is done atomically, which means that no other session can access any of the tables while the rename is running The manual does not (to my knowedge) state how this renaming is accomplished. Is an enti...
Hi Stack Overflow Community! I have the problem, that I have an migration in Rails that sets up a default setting for a column, like this example: def self.up add_column :column_name, :bought_at, :datetime, :default => Time.now end Suppose, I like to drop that default settings in a later migration, how do I do that with using rails...
I'm actually trying to get splistcp to work (referenced in hxxp://stackoverflow.com/questions/272630/how-to-documents-from-sharepoint-2003-to-sharepoint-2007-with-versioning/884609#884609), it seems perfect for my situation. However I keep getting a message saying that there was a problem accessing the destination SharePoint list web ser...
I'm using migratordotnet to manage my database migrations. I'm running them on application setup like this, but I would also like to check on application startup that the migrations are up to date, and provide the option to migrate to latest. How do I tell if there are available migrations that need to be applied? I see that I can get...
I'm migrating data from an old laptop to a new laptop, including some vb.net projects in visual studio 2008. But when I try to open some of them on the new laptop, I quickly get a dialog stating that the vb compiler has crashed and asking me if I want to close, debug, or check online for solutions. Visual studio then, frustratingly, clos...
As my previous posts can attest, I'm retrofitting in-memory, network-cached performance to what was once an entirely hibernated scenario. In doing this, I'm hitting problems where I deal with proxied objects and need to reattach to sessions, but in doing this I also want to maintain transactability. What are the best practices from movin...