====== Microsoft SQL - Datenbank migieren ======

===== Quelldatenbank analysieren =====

==== Patchlevel ermitteln ====

<code>
Select @@version;
</code>

{{:db:mssql_version.png|}}

==== DB Eckdaten ====

<code>
use master
GO
select SERVERPROPERTY ('Collation')
select SERVERPROPERTY ('Edition')
select SERVERPROPERTY ('InstanceName')
select SERVERPROPERTY ('ProductVersion')
select SERVERPROPERTY ('ProductLevel')
select SERVERPROPERTY ('ServerName')
</code>

{{:db:mssql_result_db_properties.png|}}