How to setup SQL Server database on a server for use as back-end for ASP.Net Web application?
-
Hello. I am a total newbie to SQL Server, having worked extensively on MS Access and VB 6.0 only. But now i have upgraded to Visual studio 2008 and have slowly started to update myself on the new platform. I have SQL Server 2005 and I i know how to create tables and database files. But I don't have any clue whatsoever as to how to deploy/migrate the database that I have created as on a server whose address I can reference by its IP address. Could someone help me or point me out to good articles or links to PDF's where I might find step by step instructions? By the way, my next project is a web application in ASP.Net. Thanks and regards, Kumar.
-
Hello. I am a total newbie to SQL Server, having worked extensively on MS Access and VB 6.0 only. But now i have upgraded to Visual studio 2008 and have slowly started to update myself on the new platform. I have SQL Server 2005 and I i know how to create tables and database files. But I don't have any clue whatsoever as to how to deploy/migrate the database that I have created as on a server whose address I can reference by its IP address. Could someone help me or point me out to good articles or links to PDF's where I might find step by step instructions? By the way, my next project is a web application in ASP.Net. Thanks and regards, Kumar.
Backup and Restore is the best option. Back your db up, copy the file to the server and restore it from there. Job done. In many places they use something like LiteSpeed or Red Gate's SqlBackup for this.
Regards, Rob Philpott.