?
Solved

How do I create sql scripts sql server 2008?

Posted on 2009-05-19
7
Medium Priority
?
295 Views
Last Modified: 2012-05-07
I do not want to go through table by table, function by function, etc. and create a single script for each.  I am aware of how to do that.  I need to copy pieces of the database to another database.  Not everything either so I cannot do a backup and restore type operation.

Can anyone help me here please?

In Oracle I could go into TOAD and select 1,000 objects and script them to a file/clipboard very easily.  How can I accomplish this in SQL Server 2008?

Any help would be greatly appreciated.

Thanks in advance,

B
0
Comment
Question by:cyimxtck
[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
  • 3
  • 3
7 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 2000 total points
ID: 24426026
You can generate the object createion scipt

right click on the database -> tasks- > generate scripts

ands choose the objects
0
 
LVL 5

Expert Comment

by:TheVeee
ID: 24426126
Product called AQT which costs about 199.00.   Somewhat like toad, but it will connect to any type of database oracle, db2, mysql, sql server just using odbc connections.  Cool part is that you can have it point to one environment, then have it move data to another environment schema and just pick by using the sql statement to filter.  Been using this for about 3 years now and its one of my best tools since I can also do dba work with it vice just quering  http://www.querytool.com/
0
 

Author Comment

by:cyimxtck
ID: 24426197
Perfect!  I knew there had to be a way to do that!

THanks!
0
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
LVL 5

Expert Comment

by:TheVeee
ID: 24426306
ok so did this not answer your question on how to do it?
0
 

Author Comment

by:cyimxtck
ID: 24426332
That is great but I don't want to spend $200 to do the job.  The internal functionality is what I was looking for that is in post: ID:24426026.

Thanks,

B
0
 
LVL 5

Expert Comment

by:TheVeee
ID: 24426472
Then wouldnt you want to award the points to him vice closing the question?
0
 

Author Closing Comment

by:cyimxtck
ID: 31583201
Perfect!
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

801 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