database deployment
-
hi, how to publish sql server database in server. thanks in advance!
Have A Nice Day! Murali.M Blog
-
hi, how to publish sql server database in server. thanks in advance!
Have A Nice Day! Murali.M Blog
What do you mean by "publish"? The data from a SQL Server database can be replicated many ways (backup/restore, detach/attach, ...). You need to have a SQL Server accessible by the client. If you mean publish as with a .NET program that is a different problem.
-
hi, how to publish sql server database in server. thanks in advance!
Have A Nice Day! Murali.M Blog
Development phase. 1. Create one or more scripts that create the database 2. Create one or more scripts that populate the database. 3. CHECK them into source control. 4. Label them 5. Extract USING the label and store as a 'delivery' in the file system some where. Call this location X (it will be related to a delivery version number.) Install phase 1. Notify the production personal what X is (related to the verifie version.) 2. Production personal use a dabase id SPECIFICALLY for installs, and nothing else, to run the scripts appropriately. 3. Verify that the database is 'working' using something methodology probably involving other applications. There are all sorts of variations on the above.