Capture schema structure for duplication?

  • Thread starter Thread starter Paul
  • Start date Start date
P

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
 
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'.
 
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.
 
Back
Top