I'm running some bizarre Postgres migration code from OpenCongress and I'm getting this error: RuntimeError: ERROR C25001 MVACUUM cannot run inside a transaction block Fxact.c L2649 RPreventTransactionChain: VACUUM FULL ANALYZE; So I'd like to try running it without getting wrapped by a transaction. ...
Hi there, I'm working on an application that has a read-only database shipped with it. The user will run the application and be able to select a series of "favourites" from the database which will appear in there "favourites" tab bar section. I.e. storing the primary keys. With each update to the application the read only data will p...
Suppose I have two distinct databases with identical schemas but different data. I want to merge the data between the two databases by adding the data from one into the other. Foreign key relationships, etc. need to be maintained when the data is migrated. Are there any tools (or databases that have built-in tools) to make this job fair...
I have about 30 tables in a rails app and there are about 6 tables for which I would like to change the precision and scale of some of the decimal columns. How do you go about doing that for already existing columns? Do you need to do each new migration separately, or can they all be done at once. ...
Hi all, My company's currently moving our databases around, shifting one set of tables out from the old MySQL instance into the new. We've done some development prior to this migration, and some tables' structure has been altered from the original (eg. columns were dropped). So currently I've dumped the data from the old database and ...
Hi Guys, I'm getting the following error migrating my code across from my Windows dev machine to my linxu production machine. I'm aware there are always separator and case sensitivity issues (which I have fixed), however this one seems to be coming from the Framework itself. My controllers are all following the convention (Uppercase f...
Hi! I have a rails project running that defines the standard production:, :development and :test DB-connections in config/database.yml In addition I have a quiz_development: and quiz_production: definition pointing to a differnet host/db/user/password My goal now is to define a Migration that uses "quiz_#{RAILS_ENV}`" as its database ...
We have developed a C# class library on VS 2008. We want the same functionality as a C++ library on Red Hat Linux. How do we accomplish that? I am sure we are not the first to migrate C# to C++. Are there any automated tools to convert the source code? We know about Mono, but we would very much prefer C++ source code. About 15% is the ...
I'm developing a web application for a company which I work for. My team started working on the app few months ago and the decision was to build it with ASP.NET WebForms. Now we've quite a lot of the code developed and we're wondering if ASP.NET WebForms was a good choice. Maybe we should migrate. Ok, but what's the first step? We don't ...
Using SubSonic 3 ActiveRecord, I generated code from an existing database that had foreign keys. To ensure database schema is always correct when switching databases, I placed migration code at the beginning of the app, using IDataProvider.MigrateToDatabase<MyClass>() for each class generated by ActiveRecord.tt. Turns out, migration code...
I am attempting to migrate hosts and am having issues migrating from one Drupal instance to another. I have a multi-site install. I am attempting to maintain the files/code as well as databases. I have transferred the files from the instance of Drupal from my old server to the new server. I have exported the databases via phpmyadmin ...
Hi guys, Exists a way to call .net assemblies more specific .dll files in java? I i'm developing a a framework for .net now i need to migrate it to java, i can do this? I using c# in .net. ...
Hi, I am a newbie to both Subversion and PVCS VM I currently migrated my project from PVCS VM to Subversion And I now have this structure I got the project and in my project i got my components inside each components I have trunk, branches and tags. We are trying to change the structure to have the project and then I got my components...
I am deploying a rails app to heroku which uses PostgreSQL as its back-end. In my database migration I normally set the ID field for things likes reports etc to at least 1000, most clients don't seem to like starting at 1. Normally I use mysql and I simply add an sql specific after my table creation: def self.up create_table :repor...
Any tools in Ruby or Rails that would allow me to extract from database all the table schema and generate Ruby equivalent "DLL" statements? Something that would allow me to port schema from say Microsoft SQL Server to Postgres, or MySQL to Sqlite. ...
Is there a best practice naming convention for Rails migrations, particularly when editing a model? e.g. if I'm adding a column bar to the Foo model, should I name it edit_foo or add_bar_to_foo I'm assuming if I'm editing mutliple models then I should create multiple migrations, but what if I'm making multiple modifications to a single...
Hey guys, I'm tasked with doing a SQL Server 2000 to 2005 migration. I will be doing a side-by-side migration. I've read from a few different sources that I can either: perform a backup of the database on SQL Server 2000, ship that backup to the new hardware and restore the database in SQL Server 2005; or detach the database on SQL Ser...
Hello, Can somebody please point me in the right direction for migrating a Subversion 1.4 repository to Subversion 1.6 on a different server ? I'd appreciate any help I can get, I'm not having much luck googling this. ...
This post asks how to convert from bazaar to svn. I need to do the opposite. I need to extract all the commit history from a svn repo and "replay" it on a bazaar repo. I will then drop the svn development and continue on bazaar. Any hints ? Edit: Thanks for the answer. I ended up doing as follows: 1) Performing synchronization of the...
There are about a hundred or so migrations in my migrate folder with numeric prefixes, then about a hundred or so with timestamp prefixes, so i guess at some point Rails version was updated. Now I want to go stop Rails from using timestamp prefixes as i prefer numeric prefixes. What is the best way to accomplish this, or is this even pos...