Closed

Export a SQL based DB from software A and import to Software B

We have a Medical software (lets call it Software A) which uses SQL database in the background. We want all of this data imported in another Medical software (lets call it Software B). Software B also uses a sql based db.

My client wants to stop using Software A and needs to have his data migrated to Software B.

Problems:

1. The software's are from different company so the data tables/structure is different.

2. As these are commercial software - we cant approach Software A or B to reveal their database structure.

Possible ways:

1. Both Software A & B as part of design allow export of data as XML. There could be a way to map xml files so what is exported out of A can be imported into B?

2. We also have access to the full sql db of Software A with data in it. If a tool can be written to import data out of that sql db into Software B?

We are open to suggestion and happy to work with the developer to get this solution.

Skills: Microsoft SQL Server, MySQL, PHP, SQL, XML

See more: price list import software, import export sql myadmin, import export sql code vb6, life import software, excel based road cross section indian software, home based data entry jobs vetri software, virtuemart import software, web based backpage craiglist ad posting software, ebay import software, picture import software, automated order import software, software will import listings ebay amazon, sql based accounting software, export sql data tally software, software development import, sql based inventory software, import software amazon ebay

About the Employer:
( 36 reviews ) Clayton, Australia

Project ID: #18140410

74 freelancers are bidding on average $2094 for this job

hits

I own and manage an 18 year old IT company and have a team of developers working for me. We have expertise and experience in MS SQL - we have designed large and complex database structures, have imported data from xls, More

$1666 AUD in 10 days
(960 Reviews)
9.0
TenStar718

Hello , sir. how are you? i have full experience with database management system. Let's discuss more details over chat. thank you.

$2833 AUD in 30 days
(239 Reviews)
8.6
fleetways

Thank you for looking at our bid. Maybe we should generate B XML from A XML, e.g., some offline script that can convert one form of XML to another. Guess there is going to be a need for mapping structures (schema), h More

$2500 AUD in 30 days
(88 Reviews)
8.0
sureshdevi

I will export sql based data from Software A and import into Software B support sql based database. I will complete this work in 4 - 5 days. Is it possible to show both database table structure to get better idea? More

$1500 AUD in 5 days
(1157 Reviews)
8.0
SunFlowerBiz

Hi, we have a question: What progarmming language are sofware A and software B written in? Look forward to your reply. Regards, Yolanda

$3000 AUD in 30 days
(107 Reviews)
7.7
sumon355

Hello, As an expert in SQL, i am very much interested to do this project. What RDBMS is used as database, MSSQL server or MySQL? I think we need to use both the possible ways you mentioned. First of all i need to see More

$2000 AUD in 30 days
(233 Reviews)
7.4
WebOrien

Hello nice to meet you. I am very interested in your project. I am a software expert. I am ready for you anytime I think you will get better result. I'll do my best for completing your project perfectly. Please More

$1500 AUD in 30 days
(240 Reviews)
7.1
phpdeveloper100

Ready to export system from one database to another , Please open Message box so that we discuss it in detail Expertise ================== - PHP - Cryptocurrency - Code Ignator - Magento - Laravel - Wordpress More

$2186 AUD in 30 days
(73 Reviews)
7.2
xiangang

100% JOB SUCCESS Hello client, I read your job posting carefully and am very interest your project. I am a full stack developer with great experience and skills in Web/Mobile(iOS/Android) development for over 10 y More

$2500 AUD in 30 days
(58 Reviews)
7.3
widadsaghir1993

Hello sir. Just read your job description and I am very interested in it. As a senior DB expert, I can help you well. If you share your DB for software A, B, It will be helpful for me. You can achieve your goal w More

$1500 AUD in 30 days
(71 Reviews)
6.7
DebasisB

Hi there, I am interested in the project. I have expertise in data migration with healthcare domain and I am sure I can provide you the best service you are looking for. If both systems have SQL DB and you have the acc More

$2500 AUD in 15 days
(138 Reviews)
6.9
polarjin2017

Hello? How are you? I have good experiences in "Export a SQL based DB from software A and import to Software B" as you can see my profile for these (Microsoft SQL Server, MySQL, PHP, SQL, XML). I have been working f More

$1666 AUD in 3 days
(73 Reviews)
6.5
luiswilliam

Hi. The work should be done by SQL statements that is the collections of SQL commands/Quires. Well. First way: EXPORT ---MAPPING---IMPORT, is just for part design. not for whole structure? and, next, if we can More

$1500 AUD in 2 days
(62 Reviews)
6.5
royalwebraisers

HI, I can help you in COYYING the data from once software to another although they have different structures. For this first we need both databases to understand their structure and fields, after that we will ana More

$1500 AUD in 30 days
(106 Reviews)
6.3
pofilippov

Hi there. I am the SQL expert. I have a reach experience in imports. I will be glad to discuss the project through chat.

$2058 AUD in 36 days
(25 Reviews)
6.4
Piao217

Hi I have rich experience in system development which needs complicated DB operations. I can help you with the project about import/export SQL db. I am very well-versed in SQL DB management. Please check my profi More

$1666 AUD in 30 days
(20 Reviews)
6.1
ashwanii

Dear Hiring Manager, Greetings of the day! I am interested to work on this Project. I have around 15 years of experience in Architecting solutions and implementation of successful high visibility Enterprise More

$1750 AUD in 30 days
(22 Reviews)
6.2
ssspl

Hi, We are a team of experienced professionals engaged in web applications development. We have relevant expertise in migrating data from one db to another db. We can create a middleware script which will get dat More

$2500 AUD in 15 days
(55 Reviews)
5.8
expertcoder1vw

Hi, I'm an expert SQL Server / database developer with 20 years experience, including medical information systems. Please award this job to me, I will do it properly for you, and write a utility to correctly expo More

$3000 AUD in 30 days
(44 Reviews)
5.8
DarinX

Hey! Do you want my team to a design for the project as well? If so please let me know your design preferences I think the best way to start is wireframing the project. How does it sound to you? Please take a look More

$1500 AUD in 30 days
(15 Reviews)
6.0