There may be times when you'll want to copy a MySQL database to a website. For example, if you are going to make changes to your company website, you should edit a copy of the site, not the live ...
Microsoft Excel allows you to copy Web data directly from a website using a Web query. This has the effect of giving you indirect access to the underlying database. You can pull the data directly into ...
Your third option is what you want I think. Right-click on your DB in management studio -> tasks -> copy database. It brings up a wizard that will let you choose to copy it locally without bringing ...
For instance, if you copy a SQL 2000 database to SQL Server 2008, the new copy is an upgrade to the new internal format but retains a Compatibility Level of “80” which represents SQL 2000 aka SQL 8.0.