October 4th, 2004, 11:12 AM
|
|
Contributing User
|
|
Join Date: Sep 2004
Location: herts
Posts: 37
Time spent in forums: 2 h 17 m 48 sec
Reputation Power: 5
|
|
|
script needed to find out all the data types used in a DB I am converting
I am currently trying to convert a large MS SQL database to MYSQL. One of the things I need to investigate is the data types used in both databases, and if they will be any problems. For example a Varchar in MYQSL can hold up to 255 characters, where as an SQL Varchar can hold up to 4000.
So I want to use a script that can list all of the datatypes used in the whole DB, and also list the corisponding column names.
Does anybody know how to do this? Or where i can get some good info? I am a bit of an SQL rookie... Although I have already managed the conversion using DTS - just need to tie up the loose ends.
Thanks
Will
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
