Migrating Data from SQL Express to SQL Server 2005

28 Nov 2007 6:41 PM

Saqib Ali

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/

28 Nov 2007 6:57 PM

Russell Fields

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

Show quote

"Saqib Ali" <docbook.***@gmail.com> wrote in message
news:1efb23d4-b637-4114-a64c-2703c297c9a6@b40g2000prf.googlegroups.com...
> 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/

29 Nov 2007 3:06 AM

bass_player [SBS-MVP]

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

Show quote

"Saqib Ali" <docbook.***@gmail.com> wrote in message
news:1efb23d4-b637-4114-a64c-2703c297c9a6@b40g2000prf.googlegroups.com...
> 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/

29 Nov 2007 6:56 PM

Saqib Ali

> 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/