Suljettu

Export a SQL based DB from software A and import to Software B - 14/11/2018 16:15 EST

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.

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

Näytä lisää: sql server import and export wizard download, sql server export database to sql file, sql server import and export wizard write a query to specify the data to transfer, sql export command, exporting data from sql server to csv, how to export data from sql server to excel, sql server import and export wizard connection string, exporting database from sql server management studio, 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

Tietoa työnantajasta:
( 0 arvostelua ) jodhpur, India

Projektin tunnus: #18161602

26 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

lavizsolutions

Hi,    please share me both database backup so that I can map it. 1. Case Management system. [login to view URL] you can create activity, can view on calendar, can upload docum Lisää

$2000 AUD 20 päivässä
(22 arvostelua)
6.5
BitSDestiny

I'd like to work with you on the project,Having 9+ Years of Experience as a Software Developer, successfully completed many projects (please see my reviews). Experienced in ASP.Net, C#, VB.Net, MVC, WPF,Android Appl Lisää

$150 AUD 3 päivässä
(55 arvostelua)
5.9
sopholos

Hi. I have experience in syncing different medical systems between each other. Please specify list of business objects that will need to move from one system to another. Also I will need both db to estimate.

$7222 AUD 60 päivässä
(17 arvostelua)
5.6
acronymsolutions

Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I have 20 member team of different Technology. We are working on : RDBMS :Oracle,MySQL,PostgreSQL, MSSQL Server 7.0/2000/2008R2 and Onward Lisää

$999 AUD 15 päivässä
(40 arvostelua)
5.7
C3guru

Hello, it was very interesting to read your job description and I'm sure you'll be satisfied with my ability. I've more than 5 years of Web-Program development experience - PHP, MySQL, CSS, JavaScript, HTML, ... I'll Lisää

$133 AUD 2 päivässä
(7 arvostelua)
3.7
StrongDecs

Greetings, I propose fastest delivery over top software quality Please message if the proposal makes you interested Thanks, Regards

$20000 AUD 14 päivässä
(10 arvostelua)
3.9
tsft

Dear Sir/Madam: I am interested in doing your ETL process, I can extract as you said XML, or script to extract visually, all according to system. I could connect via Chrome Remote and see it unless you already decid Lisää

$555 AUD 10 päivässä
(4 arvostelua)
3.1
rayyankabir

Hi there, I have excellent knowledge of MS SQL and XML and I can deliver you 100% of satisfaction. Like you said both software is from a different vendor and there is a lot of differences but I am very hopeful about h Lisää

$250 AUD 3 päivässä
(3 arvostelua)
3.0
sfeuh

hi, how many tables have you in the two software ???? if you want you can contact me now i am available right now. thank you

$155 AUD 10 päivässä
(4 arvostelua)
1.8
SsbasTech

Hi, Good Day! As you mentioned you have access to database A, it will the best and simplest way to do it. I am a proficient web developer working on SQL database from last 5+ yrs. I damn sure i can get it don Lisää

$111 AUD 1 päivässä
(1 arvostelu)
0.6
Skrahul72

Have 5 years of experience totally into DB administration. I suggest to use SSIS package to move the data as both the DB are in SQL server.

$55 AUD 2 päivässä
(1 arvostelu)
0.7
kamikhanvw

Hi, Good to know that both are using SQL. Can you please confirm: 1. What DBMS is being used in Application A and B? 2. Do you have DB user access to both of the databases? 3. Do you know the rules/constraints Lisää

$60 AUD 3 päivässä
(0 arvostelua)
0.0
softit1986

hi.i have more than 10 years old experience on microsft sql server.i understand what is your [login to view URL] do you which data to migrate in software B?if i write proceture do this migrate do you can run it or you want to Lisää

$167 AUD 5 päivässä
(0 arvostelua)
0.0
IntrinsecoTImx

Hello There! We are Intrinseco TI de México, we are an IT company created from the fusion of some freelancers working for world wide companies. We have a DBA Team with 15+ years of experience. We are sure we c Lisää

$250 AUD 4 päivässä
(0 arvostelua)
0.0
$155 AUD 8 päivässä
(0 arvostelua)
0.0
ganeshtrainer

I am a microsoft certified sql server developer and business intelligence developer. I have experience in migrating sql database in multiple projects. I have suggestion here instead of using xml since both are sql Lisää

$155 AUD 3 päivässä
(0 arvostelua)
0.0
holtsa

Hello, I have implemented several PHP/MySQL and MS SQL migrations in the past. MySQL itself comes from my country, Finland. I am a Microsoft certified professional with 18 years consultancy work experience. My Lisää

$800 AUD 7 päivässä
(0 arvostelua)
0.0
sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doin Lisää

$155 AUD 3 päivässä
(0 arvostelua)
0.0
sunitagiriprad

Dear Hiring Manager, Over all 15+ years of IT industry experience in Client /Server, Desktop and Window Application / Web Applications using Microsoft Technologies. • Experience in Software Development   Stro Lisää

$111 AUD 3 päivässä
(0 arvostelua)
1.5
harkeetsql

I have worked on many data integration projects where in i had to update the sql server (sql 2008r2 to sql 2012) or have to come up with a new more optimized database and do data integration. I would suggest you us Lisää

$100 AUD 3 päivässä
(0 arvostelua)
0.0