Thursday, March 29, 2012

distributed database

How to make a SQL Server database distributed?

hi,

whato do you mean by "distributed"?

if you mean, "how can I distribute/publish my database to the end user", you can think of several options..

distributing scripts to be executed, as indicated in http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx or similar solutions (see my amScript and amInsert free prjs to generate DDL scripts and INSERT INTO scripts)..

you can backup your local db and restore it on the destination server... or you can just provide the actual database files and attach them at first application startup...

regards

No comments:

Post a Comment