Hi there, Does anyone know if it 1

[dawnd3]

Hi there,

Does anyone know if it is possible to create a table design in Access and then export that design and relationships into a SQL Script?

 

[MichaelRed]

If you mean using the table builder facility in Ms. Access, I'm not aware of any way to directly convert thid to a "Script". You can, however, create a a TABLE with the characteristice of the table by using the Documentor facility in Ms. Access and have all of the information necessary for your script in a relatively "User Friendly" format. You would need to either add to or modify the table to provide some cross-reference information on the different data typing. You could also go one step further and generate the procedure(s) to export the table to SQL Server, and to use the table within SQL Server to build the 'equivalent' table in that environment.

If you are contemplating this exercise, it can only be pratical for a relatively complex db (in terms of the tables), which would (usually) include relationships between the various tables. I do not know of any way to capture these in a programatically useful manner. If you find a way, please post it here, as it would be a useful addition to the process of changing a db schema from Ms. Access to SQL Server (or other data basess).

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[dawnd3]

Michael, thank you for your post. My beau was trying to figure out a way to do this and we really appreciate your input. If we figure anything out we will certainly add to this post. Thanks again. Dawn