Script generation

Question

Script generation

byecoliz

SSC-Addicted

Points: 416
More actions
July 25, 2012 at 5:02 am

#261528

I am working with a tool that generates DDL structures for tables,procedures,functions. Apparently these are generated based on one platform MS SQL 2005. My task is to change the tool to output DDL for any given platform like oracle,MySQL e.t.c. I have the repository of this tool and I am to use Ms SQL server 2008 to develop the solution.
Please i request you help on how to start and the steps I need to come up with the solution.
Thank you .
Nat

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

byecoliz (7/25/2012)
I am working with a tool that generates DDL structures for tables,procedures,functions. Apparently these are generated based on one platform MS SQL 2005. My task is to change the tool to output DDL for any given platform like oracle,MySQL e.t.c. I have the repository of this tool and I am to use Ms SQL server 2008 to develop the solution.
Please i request you help on how to start and the steps I need to come up with the solution.
Thank you .
Nat

It is totally unclear what you are trying to do here. Are you trying to create a tool to generate tables, procs and functions in any DBMS? If so, what is the source? Where does the definition of these things come from? I can certainly tell you that using SQL to do this is the wrong way. This should be an application written in a programming language.

This being a sql server forum would be a good location to get some help with sql syntax but oracle and mysql are not likely to generate as much response.

Perhaps if you can more clearly explain what you are trying to do you might get more help.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

byecoliz SSC-Addicted Points: 416 More actions · Answer 2

Hi Sean,

The tool is a modeling tool that gives DDL scripts as a result. so apparently it gives the DDL of one platform.

with T-SQL you can develop a script generator that out puts the result according to the specified platform.

so my problem is how to develop this generic script generator in SQL server.

i hope am clear now.

thanks

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

byecoliz (7/25/2012)
Hi Sean,
The tool is a modeling tool that gives DDL scripts as a result. so apparently it gives the DDL of one platform.
with T-SQL you can develop a script generator that out puts the result according to the specified platform.
so my problem is how to develop this generic script generator in SQL server.
i hope am clear now.
thanks

Nope that isn't any clearer than before.

Let's looks at this and see if we can get some clarification.

The tool is a modeling tool that gives DDL scripts as a result.

Based on what? This is the basis of your whole process and it is unclear where this comes from.