Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Backing up data between SQL Express 2005 and SQL Server 2008 Standard Edition
1 view
Skip to first unread message
auspicious
Nov 10, 2009, 5:13:06 AM11/10/09
to
Hi,
I am developing an application which needs to backup data between SQL
Express 2005 and SQL Server 2008. My client runs with an installation
of SQL express 2005 and needs to periodically back up data to a server
database running on SQL Server 2008. The client db also receives some
new data from server and needs to update itself. The question is HOW.
Plamen Ratchev
Nov 10, 2009, 8:06:01 AM11/10/09
to
You can create a backup on SQL Server 2005 and restore on SQL Server 2008. But you cannot restore SQL Server 2008 backup
to SQL Server 2005 (as the format is not backward compatible). The standard technique is to script table structure (if
there are changes) and to export the data, then re-import on SQL Server 2005. You can also consider replication if only
specific changes need to be replicated.
to SQL Server 2005 (as the format is not backward compatible). The standard technique is to script table structure (if
there are changes) and to export the data, then re-import on SQL Server 2005. You can also consider replication if only
specific changes need to be replicated.
--
Plamen Ratchev
http://www.SQLStudio.com
0 new messages