Search code examples
sqlsql-serversql-server-2008sql-server-2008-r2sql-server-2008-express

how to pass all database (fast) since sql server 2008 express to sql server 2008 R2 (NO express)


well i had sql 2008 express, and now i have installed, sql server, now i want to delete sql express, but in that instance i have all my database i have worked (plus of 20), so they are very important for me, how can i pass it to sql server 2008 r2, i know i can do database of all but i dont want to work a lot of, there is a way short, for to pass al database? coping a folder? something? thanks!


Solution

  • I Attached all database, and i added, all (but one for one) i added all in the same windows and in 5 minutos i had all database in sql (no express)