Yii Framework Forum: Database "migration" - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Database "migration" Rate Topic: -----

#1 User is offline   mentis 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 2
  • Joined: 24-January 13

Posted 24 January 2013 - 10:01 AM

Hi,

My company has its own crm/ticket management system. It was created in early 90's and its peace of crap...
It uses mySql database, there are no relations between the tables, indexes are scarce, the DB exceeds 12GB, holding who knows how much crap data...

Im the 'lucky' one trying to make heads and tails out of it, hopefully changing it into well designed relational database with yii based app on top.

Due to the fact that the nasty DB is still in use and can not be changed for time being, I'm forced to use two databases, chunky one in read-only mode, and clean one in rw mode.

I would like to ask you, as more experienced yii developers, what would be the best way for approaching the task of recreating the table structure in new DB, in yii way, using proper relations and proper indexes.
0

#2 User is offline   jacmoe 

  • Elite Member
  • Yii
  • Group: Moderators
  • Posts: 2,601
  • Joined: 10-October 10
  • Location:Denmark

Posted 24 January 2013 - 02:03 PM

/* moved from Tips, Snippets forum */
"Less noise - more signal"
0

#3 User is offline   mentis 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 2
  • Joined: 24-January 13

Posted 25 January 2013 - 03:02 PM

Your support is stunning...
0

#4 User is offline   jacmoe 

  • Elite Member
  • Yii
  • Group: Moderators
  • Posts: 2,601
  • Joined: 10-October 10
  • Location:Denmark

Posted 25 January 2013 - 04:31 PM

Right. Do you know how little time I have?

I have time to moderate, not time to answer questions.

Is that clear?

So just put your attitude in a dark place, mate.
"Less noise - more signal"
0

#5 User is offline   outrage 

  • Advanced Member
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 313
  • Joined: 10-November 09
  • Location:Blackpool, United Kingdom

Posted 26 January 2013 - 04:08 PM

It will be hard (read impossible) to offer advice on how to best restructure your database without seeing the current schema.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users