I want to create a SQL Server Express database on my local machine and then upload it to a website that will be using the full SQL Server software - can I do this ?
views:
186answers:
6
+2
A:
The MS SQL Express databases are completely compatible with full versions of MS SQL Server. So just backup and restore.
Ilya Kochetov
2008-10-10 13:11:47
A:
Yes, they are designed to be compatible. You can either script out of the database or use the Backup/Restore functionality built into SQL Server Management Studio. More details on the latter can be found here.
Ben Hoffstein
2008-10-10 13:13:16
A:
You can move from SQL Express to the full SQL Server quite easily. There's a couple of ways to go about doing this, but the easiest is to back up the databases in question on SQL Express, install the full version of SQL Server, and restore the databases there. Both programs use the same database backup format. However both instances of SQL Server should be configured with the same collation.
Chris Woodruff
2008-10-10 13:15:16
A:
A better approach might be to buy SQL Server Developer edition. It's quite cheap and will install on a desktop O/S such as Windows XP. The main advantage over SQL Server Express is that it has all of the features of Enterprise Edition (CLR sprocs, SSIS etc.) and you can develop with this functionality. YMMV as you may or may not need these features.
ConcernedOfTunbridgeWells
2008-10-16 11:32:39
A:
You certainly can. You have a few options:
- Backup and restore
- Script everything manually
- Database publishing wizard
Microsoft SQL Server Database Publishing Wizard can be found here:
ScottStonehouse
2008-10-16 11:42:21
The other option is to detach from Express and attach on SQL Server (which is IMHO the simplest solution). Watch out for user accounts when doing this though.
Aydsman
2008-11-10 04:10:23