Generate scripts for Sql server 2000 From Sql Serv

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Generate scripts for Sql server 2000 From Sql Serv

Author

Topic

anilkumar.forum
Starting Member

5 Posts

Posted - 2009-06-25 : 06:56:31

Hi Everyone

I have a database in sql server 2005. I want to generate the scripts for this database and want to execute in Sql Server 2000 database. Can anyone help me to do this???

Regards
Anil Kumar

With Best Regards
Anil Kumar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-06-26 : 01:04:26

You can do this through the generate sql script wizard.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-06-26 : 05:57:49

quote:
Originally posted by anilkumar.forum

Hi Everyone

I have a database in sql server 2005. I want to generate the scripts for this database and want to execute in Sql Server 2000 database. Can anyone help me to do this???

Regards
Anil Kumar

With Best Regards
Anil Kumar

Use Generate script option with Script for Server Version as SQL Server 2000

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources