Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Migrating Data from SQL Express to SQL Server 2005

0 views
Skip to first unread message

Saqib Ali

unread,
Nov 28, 2007, 1:41:36 PM11/28/07
to
Is it possible migrate a database from SQL Express to existing SQL
Server 2005? It is a encrypted DB. We are reaching the 4GB limit on
Express, and would like to move the Data to a existing SQL Server
2005.

Thanks
saqib
http://www.quantumcrypto.de/dante/

Russell Fields

unread,
Nov 28, 2007, 1:57:41 PM11/28/07
to
Saqib,

The SQL Express database is fully a SQL Server 2005 database. You can
restore a backup of the database to your existing SQL Server 2005 server
with no problem.

Regarding the issues with moving an encrypted database, you might find help
on Laurentiu Cristofor's blog.
http://blogs.msdn.com/lcris/

RLF

"Saqib Ali" <docbo...@gmail.com> wrote in message
news:1efb23d4-b637-4114...@b40g2000prf.googlegroups.com...

bass_player [SBS-MVP]

unread,
Nov 28, 2007, 10:06:43 PM11/28/07
to
The beauty of using SQL Server 2005 Express is that you can move it to a
full-blown SQL Server 2005 instance with ease- attach/detach, backup/restore
or edition upgrade. In your case, an edition upgrade would be necessary as
you need to have your keys available for the encrypted databases

"Saqib Ali" <docbo...@gmail.com> wrote in message
news:1efb23d4-b637-4114...@b40g2000prf.googlegroups.com...

Saqib Ali

unread,
Nov 29, 2007, 1:56:16 PM11/29/07
to
> In your case, an edition upgrade would be necessary as
> you need to have your keys available for the encrypted databases

Thank y'all for the quick response. Can you tell what a "edition
upgrade" is? And what does it in entail?


thnx
saqib
http://www.quantumcrypto.de/dante/

0 new messages