Thursday, March 22, 2012

downgrading from 2005 to sql server express

Hi

I have a sql server 2005 database - i want to downgrade it to sql server express , i ahve tried to do a restore from a backup file from the 2005 database , I basically want to restore tables stored procs and data from the 2005 into sql server express , any ideas on the best direction for this ?

thanks

If both SQL Servers are in the same network you just register the Express with the full version and in the backup and restore wizard choose the restore from device option. If both are not in the same network then you take the .bak file and put it in the backup subfolder in Microsoft SQL Server and it is important you let Windows create the file path for you and follow the previous direction. Post again if you still have question. Hope this helps.

No comments:

Post a Comment