I have a requirement which is to create a application which is able to create databases based on another database. i need to copy only the table structures no need to copy the data.
At present im just creating SQL command objects with the comment text containing the the create table statements (which i had to hard code into the code) and use the ExecuteNonQuery() and execute. This becomes very painful when i do sme structure modification to the database (base database) as now i have to edit the database creation part. I found one method of doing it using 'SQL Server Management Objects' which generate the create table statements. but im not sure whether i can use it becos im running the application in machine which do not have a sql server installed (they connect to the sql server through LAN). So i cannot add the reference as most of the machines will be having only the .Net framework installed. if anyones interested refer below link for more details on this method. http://davidhayden.com/blog/dave/archive/2006/02/09/2795.aspx Is there another way of archiving this? thanks in advance
