• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

copy objects to SQL2005

Hi
I want to copy DB from SQL2000 to SQL 2005 server.
But I want to copy only the  Database objects to SQL2005 SERVER and not the Data .
Can some one tell me what are the ways to acheive this?

Thanks
Bala
0
MuraliPitani
Asked:
MuraliPitani
1 Solution
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
In SQL Manager you can do the following

1) Script all the tables and run the script on your 2005 instance
    - Right click on the database to copy and select "Generate Scripts"
    - Follow the wizard prompts to create all the object scripts and then
    - run the object creation scripts on your new SQL 2005 database instance
0
 
MuraliPitaniAuthor Commented:

XDJR1875 -

Although i was looking for different sloutions but i find  this as the best one.

Thx
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now