I am new to Web development and database deployment. If I'm using a SQL Server DB for a website...how do I deploy the SQLDB to another server where the Web app resides. I know when using Access, you can move the DB to where the web app is located.

Thanks,