"John Steen" <moderndads(nospam)@hotmail.com> wrote in message
news:BD83397B-F6A9-4153-ABCF-9E84D2E7AC5D@microsoft.com...
> Can I use a script generated in SQL 2005 to create a database on a SQL
> 2000
> server?
>
> We're migrating from SQL 2000 to SQL 2005, and at the same time doing a
> major upgrade to an existing SQL 2000 database.  Another group created the
> new database in SQL 2005 on a remote test server.  I connected to the test
> server and generated a script to recreate the database on another server
> running SQL 2000.
>
> Any help would be appreciated.
>
> John

"Russell Fields" wrote:

> John,
>
> As long as the script does not use any 2005 features it will work fine.  But
> if that was not thought about at script generation, then you may have a few
> problems.
>
> If you use the scripting tools in SQL Server Management Studio 2005 to
> create a script from a database on a 2005 server, you will see that you can
> choose the option to create a 2000 or a 2005 script. They are a little
> different, so if that is how they generated your script, perhaps they can
> (re)generate using the 2000 format.
>
> RLF
>
> "John Steen" <moderndads(nospam)@hotmail.com> wrote in message
> news:BD83397B-F6A9-4153-ABCF-9E84D2E7AC5D@microsoft.com...
> > Can I use a script generated in SQL 2005 to create a database on a SQL
> > 2000
> > server?
> >
> > We're migrating from SQL 2000 to SQL 2005, and at the same time doing a
> > major upgrade to an existing SQL 2000 database.  Another group created the
> > new database in SQL 2005 on a remote test server.  I connected to the test
> > server and generated a script to recreate the database on another server
> > running SQL 2000.
> >
> > Any help would be appreciated.
> >
> > John
>
>
>