New Posts New Posts RSS Feed: 200 Users MySQL Realtions Problem
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

200 Users MySQL Realtions Problem
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post Topic: 200 Users MySQL Realtions Problem
    Posted: 10-Oct-2008 at 8:58am
I am not sure that understand.  I thought that you were setting up your application for the central database in which case you should only be seeing a single database and a single application.
 
If you are running some initial application just once on every users database, then you may be right.  It may be easier and faster to use the Object Mapper.


Edited by davidklitzke - 10-Oct-2008 at 8:59am
Back to Top
DjStitch View Drop Down
Newbie
Newbie
Avatar

Joined: 01-Oct-2008
Location: Somewhere
Posts: 24 		Post Options Post Options   Quote DjStitch Quote  Post ReplyReply Direct Link To This Post Posted: 06-Oct-2008 at 2:50am

Yes Hi ...

 
Sorry the problem that I have is, I can't convert 200 users and setup database relationhips every time, It will take to long.
So what I'm asking is will the Object Mapper be powerfull enought so I  can setup these realtions manualy.
 
Then all I have to do is convert the databases then work with 1 buisness model with all the manual relationships that I have setup.
 
You see all 200 users are in different states and each one will be converted to a central databse with there own databases using MSSQL.
 
Will this work ?
 
 
 
 


Edited by DjStitch - 06-Oct-2008 at 2:52am
Back to Top
DjStitch View Drop Down
Newbie
Newbie
Avatar

Joined: 01-Oct-2008
Location: Somewhere
Posts: 24 		Post Options Post Options   Quote DjStitch Quote  Post ReplyReply Direct Link To This Post Posted: 05-Oct-2008 at 11:41pm
Thanks fot your input......
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post Posted: 03-Oct-2008 at 8:55am
I would choose Option 1.
 
I would start with a converter tool if you have one that you like.  Then I would add the relations to the database manually rather than use the Object Mapper.  If you do this right, when you open up the Object Mappe for the first time, all your relations should be there.
 
DevForce won't help you with the conversion process.  It will help you in your development once you have finished your conversion.


Edited by davidklitzke - 03-Oct-2008 at 8:56am
Back to Top
DjStitch View Drop Down
Newbie
Newbie
Avatar

Joined: 01-Oct-2008
Location: Somewhere
Posts: 24 		Post Options Post Options   Quote DjStitch Quote  Post ReplyReply Direct Link To This Post Posted: 02-Oct-2008 at 4:20am
Hi There
 
Problem:
I'ff got 200 users, all on a rich, 2-tier, VB6 program that I want to change to a smart client, central database, n-tier, .net application, All of my users have got MYSQL as there databases with a MYISAM structure.
 
I was told that with MYSQL the table format needs to be INNODB for relations to work and all my clients is set to MYISAM.
 
No in your point of view - what will be the right way to do this.
 
1: Use a convert tool like "Full convert entrprise" and convert all the tables to MSSQL and do development on seting up manual relationship between tables, leaving the new MSSQL database structure like is.
 
2: Create a all new database using MSSQL with relations,
But then how will I convert all my 200 users then. My users is all remote users with different MYSQL databases witch sits localy on there drives.
 
 
How and what steps must I take to use "Devforce" for this development - I AM WILLING TO BUY THE NEW DEVFORCE EF IF you can give me a solution.
 
 
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down