MS SQL Server - SQL 2005 to 2000 database migration

Author

SQL 2005 to 2000 database migration

2006-02-15, 11:23 am

Hi,

I've developped a database driven application using Visual Studio and
the SQLEXPRESS that comes with it. Since I haven't used any features
specific to SQL 2005 I wasn't really concerned about the migration to
SQL2000 which is the only production server that we have in the place I
work.

I just needed tables, views and stored procedures to be migrated. I
don't need data migration.
I was hoping to use the scripting feature of the SQL Server Management
Studio but the script that it produces does not run on SQL2000 even
though I chose the SQL2000 option in the wizard.
It seems I'm not the only person suffering from this bug:
http://forums.microsoft.com/MSDN/Sh...166757&SiteID=1

Is there any other way to create my tables, views, etc. on SQL 2000.

Thanks,

Uri Dimant

2006-02-16, 3:23 am

cc
DTS Package is your friend in that task

"cc" <steelj@gmail.com> wrote in message
news:1140022020.411903.260170@z14g2000cwz.googlegroups.com...
> Hi,
>
> I've developped a database driven application using Visual Studio and
> the SQLEXPRESS that comes with it. Since I haven't used any features
> specific to SQL 2005 I wasn't really concerned about the migration to
> SQL2000 which is the only production server that we have in the place I
> work.
>
> I just needed tables, views and stored procedures to be migrated. I
> don't need data migration.
> I was hoping to use the scripting feature of the SQL Server Management
> Studio but the script that it produces does not run on SQL2000 even
> though I chose the SQL2000 option in the wizard.
> It seems I'm not the only person suffering from this bug:
> http://forums.microsoft.com/MSDN/Sh...166757&SiteID=1
>
> Is there any other way to create my tables, views, etc. on SQL 2000.
>
> Thanks,
>

Sponsored Links