Wednesday, March 28, 2012

Migrating Data from SQL Express to SQL Server 2005

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/
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" <docbook.xml@.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/
|||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" <docbook.xml@.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/
|||> 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/

No comments:

Post a Comment