I need a database migration framework for SQL Server, capable of managing both schema changes and data migrations. I guess I am looking for something similar to django's South framework here. Given the fact that South is tightly coupled with django's ORM, and the fact that there's so many ORMs for SQL Server I guess having just a gener...
My situation is similar to this question. I am using lightweight migration with the following code, fairly vanilla from Apple docs and other SO threads. It runs upon app startup when initializing the Core Data stack. NSDictionary *options = [NSDictionary dictionaryWithObjectsAndKeys: [NSNumber numberWithBool:YES], NSMigratePersisten...
Are there any tutorials for FluentMigrator? Some "Getting Started..." tutorial would be just awesome. All I was able to find was FluentMigrator.Tests (unit tests), inside FluentMigrator source, which are not as helpful as "Getting Started..." would be. ...
Which cloud providers accept the shipping of disks with very large amounts of data (say, several Terabytes) for data migration (instead of having to transfer massive quantities of data over wires)? I know that AWS currently offers this kind of service; even so, I was not able to get answers for this question with respect to Azure, Force...
Is there a nice tool to convert gdbm file to sqlite database file? ...
Hi guys, Let's say if I have a table "PersonData" in which 4 of its columns are FromPersonId, FromEmployeeId, ToPersonId, ToEmployeeId Any of the records only ever contains Only one From** and Only one To** and the other two columns are null. Also FromPersonId and ToPersonId belong to "Person" table and FromEmployeeId and ToEmployeeId...
We are running a PHP (zend framework) app that creates a database per user (for security/backup/and others reasons). All these databases have exactly the same structure and that will always be the case. When we deploy new features we'll need to expand all databases with the new fields/tables. I've read about using dbdeploy for that, but...
Hi guys, We have a normalized SQL Server 2008 database designed using generic tables. So, instead of having a separate table for each entity (e.g. Products, Orders, OrderItems, etc), we have generic tables (Entities, Instances, Relationships, Attributes, etc). We have decided to have a separate denormalized database for quick retrieva...
I want to do that using a code and not using a tool like "MySQL Migration Toolkit". The easiest way I know is to open a connection (using MySQL connectors) to DB1 and read its data. Open connection to DB2 and write the data to it. Is there a better/easiest way ? ...
My iPhone app will have read-only "system" data AND read/write "user" data (stored either using Core Data or a custom SQLite db). The user data may reference the system data. When a new version of the app is installed (e.g., via iTunes): The new system data that comes with the update should overwrite/replace the old system data The use...
What is best way to best way to migrate data from one product to another if both software companies refuse to reveal the database structure to one another? ...
I have an extensive maintenence plan on one sql server 2008 instance that I wish to move to 4 other instances. What is the best way to do this other than rebuilding it on each server? Thanks ...
I've been working on a rails project, in which I need to firstly seed the database and then update the data periodically. The unfortunate problem is that I seem to want to update the same set of data multiple times. Hence I would like to use the same migration name...but the rails generator seems to complain about the naming. This lead...
I have 2 identical tables in 2 different databases that reside on the same server. What would be the best way to copy data from table to another? ...
I'm in the process of importing data from a legacy MySQL database into SQL Server 2005. I have one table in particular that's causing me grief. I've imported it from MySQL using a linked server and the MySQL ODBC driver, and I end up with this: Col Name Datatype MaxLen OrderItem_ID bigint 8 PDM_Structure_ID int ...
How to migrate sql server 2008 to my sql 5.0 programmatically? any link? EDit:- Sorry for not asking question properly,See we will be getting sql server backup from client every night,and we have to load it to my sql every night.so we my solution is t0 try transtional replication.so i am trying heterogenous subscriber as my sql and prov...
I need to migrate a complex project from sqlite to PostgreSQL. A lot of people seems to have problem with foreign keys, data truncature and so on... Is there a full automated utility ? Do I need to check some data or schema before the migration ? Edit : I tried django-command-extensions DumpScript but it doesn't run on my 2GB RAM PC...
I have a database on Oracle 9i. Now I want to work on SQL Server 2008. I want to migrate the Oracle database to SQL Server, but how do I do that? Give me some syntax? Thanks for the help. ...
I have a database table called A and now i have create a new table called B and create some coloms of A in table B. Eg: Suppose following colomns in tables Table A // The one already exists Id, Country Age Firstname, Middlename, Lastname Table B // The new table I create Id Firstname Middlename Lastname Now the table A will be look...
I am experienced with Spring, but new to Spring Batch. Now I have the task to migrate a data structure from a simple structure in one database to a complexer one in the other. The data structure corresponds to an object hierarchy that I will name like this OldParent 1 --> n OldChild // old system NewParent 1 --> n NewChild // new syst...