I am charged with creating an export from several tables in one database to a identically configured tables in another database, so first I have to create the identical configuration in the second database.
The problem is, when the first database was set up, they used what seems like hundreds of user defined types. I am not the greatest typist in the world and recreating these on the second database is going to a nightmare.
These user-defined types must be stored someplace, but I can't find them. I am thinking if I found the location where these types are stored, I could copy them to the second database and avoid trying to fat-finger though a couple hundred user-defined types.
Can anyone tell me where these types are stored, or of there is another way to solve my problem?
Thank you.