Solved

copy objects to SQL2005

Posted on 2008-06-13
2
161 Views
Last Modified: 2011-10-03
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
Comment
Question by:MuraliPitani
2 Comments
 
LVL 17

Accepted Solution

by:
xDJR1875 earned 250 total points
ID: 21780255
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
 

Author Comment

by:MuraliPitani
ID: 21856387

XDJR1875 -

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

Thx
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now