Solved

MS SQL Data Migration Script Verification

Posted on 2011-02-26
2
459 Views
Last Modified: 2012-06-27
Hello Experts,
I am  MS SQL novice who is working with another individual who is SQL novice but good at scriping. I am installing new electronic medical records software for one of my clients and need an expert to verify the script this individual has created for me to make sure the process is sound and is not going to cause problems.

Basically, he has written a script to import demographic patient data in the form of a .csv file (name, address, etc) into a MS SQL 2008R2 database table. I need an expert to look at the process and confirm it is not going cause any unforseeable harm. We already ran the script in a lab environment and it works fine. I realize that this post might be beyond the scope of EE and if so...I would be happy to hire one of you directly. Documentation and scripts are attached. SQL-Insertion-Protocol.pdf
SQL-script-sample.csv
SQL-script-sample.sql
MISC-CSV2T-SQL.awk.txt
0
Comment
Question by:JohnnyD74
2 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 500 total points
Comment Utility
Dear Asker,

Your demand requires a carefull and long time study.. You may demand help from one of the experts who are open to jobs and have contact information in their profiles.

It is against the rules to offer paid work in an EE question.  What you can do, however, is browse the profiles of Experts that you like.  Many of the Experts here are open to job offers; those who are will typically state that in their profiles along with contact information.
0
 

Author Closing Comment

by:JohnnyD74
Comment Utility
Thanks...I will do that.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now