April 29, 2002 at 5:53 am
Hi *,
I'm looking for tools that generate an update sql script between 2 ODBC DB sources ( so not mssql specific). It's not the data I'm interested in, just the table structure and all other db objects.
Any ideas?
April 29, 2002 at 5:59 am
Don't know of a specific product as most I have seen are specific to a particular database. Whatare the two sources and how do you want to do it based on what they are capable of?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 29, 2002 at 6:27 am
For example, i've been looking at DBdiff and dbscripter, products on http://www.dkgas.com/ . The tools can e.g. connect to an mssql and generate a script for oracle, sybase and other odbc sql's syntax.
I'm in a multi rdbms environment where i need to deliver updatescripts and complete scripts of the various DB versions. Because the tools i mentioned seem to have a problem with declaring prim keys, i was looking for alternatives.
April 29, 2002 at 2:19 pm
I have not seen anything like that. But one would think there got to be a product available in the market to do that. Just a thought - it is a lot easier to develop one (custom made) for you using VB. If you need any help with that, contact me.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply