i remember in my previous job, i needed to do data migration. in that case, i needed to migrate to a new system, i was to develop, so it has a different table schema. i think 1st, i should know: in general, how is data migrated (with the same schema) to a different DB engine. eg. MySQL -> MSSQL. in my case, my destination DB was MySQL ...
I have .xdr file and I need to store it's data into mysql database. How should I do this? Thank you! ...
I would like to copy parts of an Oracle DB to a SQL Server DB. I need to move the data because the Oracle box is being decommissioned. I only need the data for reference purposes so don't need indexes or stored procedures or contstaints, etc. All I need is the data. I have a link to the Oracle DB in SQL Server. I have tested the f...
I'm porting a sybase application to mysql and of course there's tons of sql compatibility issues, but one that I don't see an easy way out of without changing every single sql is that in sybase you can refer to a table by db..table notation, but in mysql it requires db.table. I'm kinda on mysql's side on this one, but this is what it is....
We have an MS Access .mdb file produced, I think, by an Access 2000 database. I am trying to export a table to SQL with mdbtools, using this command: mdb-export -S -X \\ -I orig.mdb Reviewer > Reviewer.sql That produces the file I expect, except one thing: Some of the characters are represented as question marks. This: "He wasn't re...
Hi, guys! I'm trying to make an online dictionary for my own purposes (I know there are some other dictionaries, but they don't have what I need) and I have a file with words in the following format: 戚谊 戚誼 [m1][b]qīyì[/b][/m] [m2]some translation[/m] 三州府 [m1][b]sānzhōufǔ[/b][/m] [m2]translation #2[/m] First two lines ...
Sorry for duplicating this question, but here I tried to explain it in more details. I need to parse the data from certain file and store it to database (MySQL). This is how the data is displayed in the file: 戚谊 戚誼 [m1][b]qīyì[/b][/m] [m2]translation 1[/m] [m1][b]qīyi[b][/m] [m2]translation 2[/m] 三州府 [m1][b]sā...
I am working on a site that lists a directory of various restaurants, and currently in the process of switching to a newer CMS. The problem I have is that both CMSes represent the restaurant data differently. Old CMS A Cross Reference Database so it may list an entry for an example like this: ID / FieldID / ItemID / data 3 / 1 / 6 / ...
Hello, I need to migrate data in a large flat table located in SQL Server 2005 into a new SQL Server 2005 schema that consists of a parent table and multiple child tables. This seems like the opposite of a merge or merge join in SSIS but I don't understand how I would go about accomplishing this. Any recommendations are greatly apprec...
Tarantino requires that you point it to a scripts directory that contains two subdirectories, create and update. When Tarantino's create or rebuild action is executed I expected sql scripts in the create directory to be run, followed by, in the case of the rebuild action, any scripts in the update directory. I've found that scripts in...
Hi, Anyone have a PL-SQL statement that i can use to generate database & tables schema for specific database on Oracle 10g? I need the schema in .sql file and if possible compatible with ANSI-92/99 sql implementation, so i can use the generated .sql directly on sql server 2005. Already heard about exp/imp, but it seems generated dump f...
I want to start using Core Date on iPhone with pre-existing MySQL databases. What's the easiest way to transfer a MySQL database to SQLite? I've tried using SQLite Migrator, but I don't know where to find the ODBC drivers for Mac (Snow Leopard). I found http://www.ch-werner.de/sqliteodbc/ which seems to have drivers, but they are for Po...
I've been using git-svn to work with svn repository A, and now I need to move the project over to repository B. I could just use svn to import the lastest HEAD from A. But I'd like to preserve the history if there's a way. Is there a way to do this? Can I add repos b as a remote branch and dcommit to it or something? Not sure. ...
I have some 20 excel files containing data. all the tables have same columns like id name age location etc..... each file has distinct data but i don't know if data in one file is again repeated in another file. so i want to join all the files and the result st should contain distinct values. please help me out with this problem as soon ...
Oracle's table server offers a built in function TRUNC(timestamp,'DY'). This function converts any timestamp to midnight on the previous Sunday. What's the best way to do this in mySQL? Oracle also offers TRUNC(timestamp,'MM') to convert a timestamp to midnight on the first day of the month in which it occurs. In MySQL, this one is st...
I know this is a task that can't be unique, but I can't seem to find a way to do what I'm thinking in my searches and reading, so if it's not possible, I'd like to know if I'm choosing the best alternative. Simple case of moving information on people from the old database to the new. The problem is that the old schema has the address on...
We have 200+ views in Oracle that should be transfomed to 200+ flat files with fixed length fields. Hoping to get ideas to do a better design of the following migration routine. The prototype of migration program looks like this for the view named VIEWNAME1 (and are the same for other views in the prototype): StronglyTypedDataSet view...
Hi, I have two rails applications. I would like to submit data from one application to another but I want it go through the controller logic as it's not just a DB dumb. I tried using directory HTTP call with POST but it didn't work as it asked for Authenticity Token. Now that I own both apps what is the easiest way in your opinion to d...
I created a Django app that had its own internal voting system and a model called Vote to track it. I want to refactor the voting system into its own app so I can reuse it. However, the original app is in production and I need to create a data migration that will take all the Votes and transplant them into the separate app. How can I ...
I am trying to write a data migration pl/sql script to transfer some of the data in one schema to a different schema on another server. The second database started as a subset of the original database, but we have modified the schema. So I can't just use the following for each table: Insert into DB2.table_name select * from DB1.table_n...