Hello,
I have huge SQL script in single file. It includes data definitions (drop/create/alter tables, procedures, etc) which are grouped logically. E.g.
1. First, N queries to delete all tables/procedures
2. Then, M queries to create/alter all tables
3. Then, K queries to create all procedures
I need a tool (preferable on .NET), which will parse this single file script, and has two options:
1. Dump by groups: it should create 3 files: [login to view URL] (contains all queries to delete all tables/procedures), [login to view URL] (all queries to create/alter all tables), [login to view URL] (all queries to create all procedures). If I merge those 3 files, result should be the same as original script
2. Dump by tables: it should create N <table_name>.sql files. Each SQL file should contain TABLE related stuff (everything for altering, creating, dropping this table, and stored procedures, which work on this table only).If procedure works with more then single table, script should check to which table it should be assigned, using some configuration file. If it's missed, then create __proc_<proc_name>.sql file for it.
All comments and manipulators (e.g. SET QUOTED_IDENTIFIER OFF) have to be preserved.
Take a look at attached [login to view URL] for example. I will share more complicated file, if you accept the project.
helllo, I have worked both full time and part time as a Windows desktop/embedded *C/C++(MT4, 5)/C#
developer for over 7 years now,
I have done many simple and complex projects with Visual Studio and C++, some linux-things too,UNITY for game development. I also do JAVA tasks on eclipse and netbeans. I have the knowledge of how to debug PHP issues,wordpress plugins that are buggy and need fixes.... or some extra functionality is needed.
I also like doing Javascript frontend things - especially some WebGL, SVG or similar graphics/canvas related things
I will be more than excited to provide you a quality solution and earn your respect, confidence and trust
I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday duties were: development of different types of reports, dashboards, KPIs, ETLs and functional modules for application`s data layer, Investigation and resolution of performance and locking issues on high loaded production environment. You could accept me and i will share my expertise with you.
Hi, I have read your project description and willing to do this for you in your required time spam with 100% Satisfaction. Kindly message me so we can discuss in detail over chat......
Hi there!
I have seen your job post and understanding deeply.
I have enough experiences with C#, Java, Python, Web scraping, Meaning learning & Console game, etc…
I am also expert that have enough knowledge with Algorithm, Mathematics, statistics Analysis, Neural Network & Economics.
Please ping me via chat, I promise you will see perfect results for your wishing within your deadlines.
Have a sweet time.
Thank you for your consideration, Raisa.