For some purchase, you might want to show the database from your instance and you are actually could done it with just a query.
With the simply query as below, it will show all of the databases from your instances.
SELECT * FROM sys.sysdatabases
MySQL database is one of the famous database engine used from the IT world.
To you might have a question such as how to move the current hosted database to another server? Actually it is very easy through the command line.
You may refer to the step as below to restore your database file.
Restore database with password.
mysql -h [remote_IP] -u [username] -p [password] [database_name] < [database_name].sql
Restore database without password
mysql -h [remote_IP] -u [username] [database_name] < [database_name].sql
Restore database from the remote server(you’ve logged into the server that wish to restore database)
mysql -u [username] [database_name] < [database_name].sql
For a database administrator , please aware that SQL Server 2008 will now have new datatypes as below are the list.
DATE – ANSI-compliant date data type
TIME – ANSI-compliant time data type with variable precision
DATETIMEOFFSET – timezone aware/preserved datetime
DATETIME2 – like DATETIME, but with variable precision and large date range
GEOMETRY – “flat earth” spatial data type
GEOGRAPHY – “round earth” spatial data type
HIERARCHYID – represents hierarchies using path enumeration model
The first four datatypes are regular SQL datatypes but the last three datatypes are exposed as .NET system UDTs.