General task explanation: When creating a new database, by default it is being assigned with logical names for the actual files according to the Database Name. For example – in the database below “xglobedb”, you can see to logical names opened automatically (xglobedb & xglobedb_log).

So, for new databases – all nice and peachy.

The problem is that if a database has been copiedor restored from a .bak file the client uploaded himself and was not normalized, it will contain the wrong logical name. This will be problematic later for the import script.

For example – you can see some inconsistencies below – “keeper_phone” and “keeper_birds” both have the same logical names: “DataMining2013” – this is probably because they were copied from the same database twice. “keeper_dogs” was probably restored from a client-uploaded “.bak” file without normalization.

General Task Description: It is possible to migrate the SQL Users along with the password (even if you don’t know it) and with its original SID and to have it recreated at the destination SQL server. This means there will be no “orphaned” users and you won’t need to create logins / password reset anything. Pretty neat.