Friday, March 23, 2012

Rebuild SQL Server Express database on a SQL Server 2000

Hi,
Anyone know if it's possible to rebuild a
SQL Server Express database on a SQL Server 2000?
Thanks!
Regards
D.Dahab wrote:
> Hi,
> Anyone know if it's possible to rebuild a
> SQL Server Express database on a SQL Server 2000?
> Thanks!
> Regards
> D.
>
No - you can't go from SQL2005 to SQL2000.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||The easiest way is to use SSIS Import and Export Wizard to migrate the data
(assuming you have a higher version of SQL Server 2005 around somewhere).
This way the data mappings will get done for you if you have used some
incompatible features.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks Paul!
D.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23UKL2oGbHHA.4312@.TK2MSFTNGP05.phx.gbl...
> The easiest way is to use SSIS Import and Export Wizard to migrate the
> data (assuming you have a higher version of SQL Server 2005 around
> somewhere). This way the data mappings will get done for you if you have
> used some incompatible features.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>

No comments:

Post a Comment