|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
convert SQLServer 2005 to SQLServer 2000hello,
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***@yahoo.de> wrote in message Show quote news:1169726869.451045.129600@a75g2000cwd.googlegroups.com... > hello, > > does anyone know a tool to convert a SQLServer2005 database to > SQLServer2k? > > -- > candide_sh > Hello,
candide***@yahoo.de wrote: > does anyone know a tool to convert a SQLServer2005 database to you could try the "Microsoft SQL Server Database Publishing Wizard 1.0"> SQLServer2k? http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=29B4FFD8-AC3A-4481-B352-9B185619A901 <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 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: Show quote > Hello, > > candide***@yahoo.de wrote: > > does anyone know a tool to convert a SQLServer2005 database to > > SQLServer2k?you could try the "Microsoft SQL Server Database Publishing Wizard 1.0"http://www.microsoft.com/downloads/details.aspx?displaylang=en&Family... > > <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  |
|||||||||||||||||||||||
Other interesting topics