6 replies to this topic

[doubleotwo]

Hello all,

Let me start by saying im not a total noob....

Context:

I got a program which is written in an old code ... this program has a DB and this DB is absolutely not compatible with SQL server... so me and my client decided to make the syncing of the databases simply by always making a txt file ( or whatever ) in which the database changes are written, this txt gets picked up by a webservice, lets say every 15min...
or in fact manually by a pageload in a website ( if this is possible )

this proces needs to be the other way around too, so the website can make changes on some tables, which needs to be synced to the old db as wel, this is done probably by the client himself cuzz he has the knowledge of the old language program ...

My question here is :

how do i best realise this, with a webservice like i said ? or are there alternatives...

i think i need to make a program that reads a txt file and make this update/insert/delete records in the database
and this exe needs to be called by a webservice which is programmed to do this every [time interval]

all remarks are very welcome :)

[WingedPanther]

What is the old database? Why are they "absolutely not compatible"?

[doubleotwo]

its a database of prologue...

i dont know it but its very old...

it keeps 1 file for index and 1 for data... thats all i know aboutit :)

[doubleotwo]

so i probably need to read the datafile and insert this into my SQL databse via a program, where i can set the mappings of the data and the corresponding columns....

but the rest of my tasks, like the synchronizing ... is this idea of me correct ?

[doubleotwo]

actually i dont need the webservice at all.... i only need a synchronizeprogram.exe that i can call with specific parameters ( fe. full database restore via txtfile, or just updates )

this parameter will result in checking a different folder on the server... this exe i can schedule on the server to be called at every 15 min or so....

this will eliminate the need for a webservice ....

now im searching which kind of app i need to select in VS2008 to make something like that

[ManyTimes]

>>this proces needs to be the other way around too, so the website can make changes on some tables, which needs to be synced to the old db as wel
Why do you need two different DB systems? One is backup other isn't? Well... Why not just use SQL on both, take everything from the Prologue DB and stuff the two SQL databases with it...? Then later on you only need to sync two SQL databases...
Get rid of either the SQL DB or the Prologue DB is my suggestion... :)

>>im not a total noob...
>>i only need a synchronizeprogram.exe that i can call with specific parameters
>>now im searching which kind of app i need to select in VS2008 to make something like that
So, you've gotten as far as installing VS 2008, and now you are stuck at "File-> New -> Project"...
Well, what experiences do you have? Visual Basic? C#? C++? Java? None? I am talking about programming-languages...

I would go for Visual C# -> "windows form application" or "asp.net web application"... :) lol
If you were stuck even here, oh, long way to go...

[doubleotwo]

dont mock me cuz i dont know the project

i know how to program, its just that other stuff that confuses me :p

i know C# VB.NET bit of java, lot of js, jquery and all that ****