Database made in sql server 2000 can be shifted into sql server 2005?
Yes, a Microsoft SQL Server 2000 database can be hosted on a Microsoft SQL Server 2005 server, and it can also be upgraded to a 2005 database structure under the database properties.---------------Yes it can. You can just attach the mdb file with no problem. 2005 & 2008 are fully compatible with 2000 database files.The action of changing the Compatibility level to the latest value is really optional. I recommend NOT "upgrading the compatibility level". Performance wise, there is no advantage in speed. The Compatibility level is there to ensure features used in the 2000 database are made available to it (ie, some functions are renamed in later version, some are deprecated, etc). So, unless you've done a thorough check (or a very sure), I recommend leaving it at 2000 compatibility.-----------------Yes absolutely, you can do it. Here is top 4 methods that will help you for this.1. Backup & Restore2. Detach & Attach3. Generate Create Script4. Copy Database Wizard using SSMS
- In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
- Expand Databases, and then right-click the database that you want to shrink.
- Point to Tasks, point to Shrink, and then click Database. Database…
- Click OK.
- Access MySQL database from C Program To access MySQL database, you need to have the mysql-devel package on you system. This package provides the share libraries and header files required to MySQL client program development. Header files are required for program compilation and shared libraries are used at run-time.
We've handpicked 21 related questions for you, similar to «Database made in sql server 2000 can be shifted into sql server 2005?» so you can surely find the answer!