Solved

copy objects to SQL2005

Posted on 2008-06-13
2
166 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 17

Accepted Solution

by:
Daniel Reynolds 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

749 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