Capture schema structure for duplication?

[Paul]

I am building a complex database on SQL Server using an Access Data Project.
If all goes well, I will be utilizing the same database for my other
clients, so I need to re-create the db structure on their servers as well.

I can not find any way in Access 2000 to script the table schema or
otherwise grab the structure information so I can duplicate it.

Is this possible?

Thanks.
Paul

 

[SFAxess]

You can have SQL Server create a script that build the
database using the Enterprise Manager. Right click on the
object(s) and select 'All Tasks' then 'Generate SQL
Script'.

 

[Sylvain Lafontaine]

One problem that come often is to synchronise the schemas of existing
databases without erasing the datas.

Personally, I use SQL-Compare from Red-Gate Software and I'm well satisfied
with it. There are also other products on the market.

S. L.