Hi, using Access 2003 and sql 2005, I want to programmatically build a sql
database using another database as the template. That is, the new database
needs to contain copies of tables (in some cases also data), views, stored
procedures, functions, triggers and so forth from the source sql database.
I am considering using sqldmo to transfer object by object to the new
database. Is this the 'best' method? Will sqldmo work for sql 2008 as I
vaguely recall reading somewhere that sqldmo is a legacy object library?
Any recommendation or suggestion appreciated :-)
Many thanks,
Jonathan
|
Similar Threads
