Thursday, March 8, 2012

convert SQLServer 2005 to SQLServer 2000

hello,
does anyone know a tool to convert a SQLServer2005 database to
SQLServer2k?
candide_sh
Hello,
As far as I know there is no toool to do that. Only possibility is by
installing SQL 2000 and use DTS / SSIS to copy objects and Data from SQL
2005.
Thanks
Hari
<candide_sh@.yahoo.de> wrote in message
news:1169726869.451045.129600@.a75g2000cwd.googlegr oups.com...
> hello,
> does anyone know a tool to convert a SQLServer2005 database to
> SQLServer2k?
> --
> candide_sh
>
|||hello,
I downloaded DB Publishing Wizard, had a little issue with one UNICODE
value, did a manual workaround and all is fine.
thanks
On 26 Jan., 07:25, Gerald Aichholzer <gerald.aichhol...@.gmx.net>
wrote:
> Hello,
> candide...@.yahoo.de wrote:
> <quote>
> SQL Server Database Publishing Wizard enables the deployment of SQL
> Server databases into a hosted environment on either a SQL Server 2000
> or 2005 server. It generates a single SQL script file which can be used
> to recreate a database (both schema and data) in a shared hosting
> environment where the only connectivity to a server is through a
> web-based control panel with a script execution window. If supported by
> the hosting service provider, the Database Publishing Wizard can also
> directly upload databases to servers located at the shared hosting provider.
> </quote>
> HTH,
> Gerald

No comments:

Post a Comment