hyy... i hv aproblem.. iwant to make aplication thabt need some field database from other database(pg-sql) and want to copy it to other database(mysql). can that skrip make this happen auto copying...?
forzadraco 0 Junior Poster in Training
AaronASterling 0 Light Poster
hyy... i hv aproblem.. iwant to make aplication thabt need some field database from other database(pg-sql) and want to copy it to other database(mysql). can that skrip make this happen auto copying...?
sure....probably....kinda. You just need to read the data out of the source table in the old database and write it into the new table in the new database. Thats the "sure" part of the answer. the "kinda" part of the answer is that stored procedures and triggers will need to be rewritten as well as keys, rules and defaults. The "probably" part is that these may or may not be a major part of the database and so if its just a simple database, as most of them are, then you should be able to do it without too much of a hitch.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.