There is POSTGRESQL sump file which extension is SQL. Need someone's help who can load that file into POSTGRESQL and write SSIS package or some mechanism so we can transfer the data from PostgreSQL to SQL.
Dear Sir,
It’s a great pleasure me to bid on your project. I am a 7 years experienced web Developer.. I hold a master degree for Computer Science. Please see my profile, I have enough experiences and gained lot of job experiences working in various world recognized institutions.
I am maintaining 100% on time job completion rate with 5 star rating in freelancer.com customer reviews. And also I have passed the necessary skill examinations in freelancer.com which are related to complete your project.
Please send me your POSTGRESQL file, I will check and let you know what i can do on this matter..
Have a wonderful day sir..!
Hi there,
I can help you with it. Just want to clear up couple of things:
1. do you have a control over the pg_dump execution (so you can affect the output format of the PostgreSQL dump);
2. do you need the DB/Table creation part on the SSIS? - most probably you just need "insert" statements to carry the actual data from pgsql into sql...
3. do you have a place to test it? - I have some PgSQL servers at hand, but most probably won't be able to find operational SQL to test import part of it.
Regards.
Good day!
I have a wide experience of work with SQL. Is ikchestvenno ready to carry out in terms a task.
Question: it is required to load into Microsoft SQL Server? What version?
I have very good working experience in transfer reporting from Excel to SSRS/SSIS Packages.
I Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
Hello,
I am an SQL expert I have experience for more than 12 years, please send me your file so I can take a look, and I will be glad then to do the job for you.
Thanks,
-Shomaf
Hello there!
I can help you easily with this. Here is what we can do: I have already PostgreSQL installed in a Linux virtual machine, and I have MS SQL Server 2008 R2 on my laptop. Depending on the size and complexity of you database I will have to analyze the best way to do this transfer. In the end, I would provide you with a MS SQL Server backup file (or any preferred MS SQL Server file you want).
Hi!
Depending on the amount of data I can get this done in a day or so
Please can I ask is the target database MySQL(mysql, percona, mariadb) or MSSQL ?
Best Regards
Oliver Hough
Hell-
We are experienced ETL( Extract Transform and Load) professional, certified in Informatica (ETL tool). We mainly deals i n extracting, transforming and loading data from discrete systems for reporting and analysis.
We can read POSTGRESQL sump file as text file and load into any database yo would like.
Hire us as a freelancer and we will make sure that the outcome exceeds your expectations & Budget.
Thanks, looking forward to hear from you soon.