I have SQL Express 2008 R2 with an instance called "SQLEXpress" installed on Windows XP Pro machine.
I need to replace the Windows XP machine
I have installed SQL Express 2012 on a Windows 7 Pro machine.
Created an instance called "SQLExpress"
What is the best way to transfer the SQLExpress databases from the XP machine to the 7 machine?
The Import/Export function does not transfer schema.
The generate scripts function generates a 8GB SQL file. I have tried to run using sqlcmd command line tool but fails with some syntax errors and due to the size of the file I can't open and fix.
Any advice would be greatly received.