I have an application for monitoring the performance of an enterprise which i want to be used by multiple enterprises.My requirement is开发者_开发问答 to create a new database for each user enterprise based on the database i have created initially . Can any body help me with some sql script or a link . I am using .net4 and c # , SQLSERVER 2008 . Thanks
In Microsoft SQL Server Management Studio, you can right click your initial database, 'script database as' => 'create to' and save where you want. You can then use this script to deploy your database multiple times.
精彩评论