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

How do I create sql scripts sql server 2008?

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
cyimxtck
Asked:
cyimxtck
  • 3
  • 3
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
You can generate the object createion scipt

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

ands choose the objects
0
 
TheVeeeCommented:
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
 
cyimxtckAuthor Commented:
Perfect!  I knew there had to be a way to do that!

THanks!
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
TheVeeeCommented:
ok so did this not answer your question on how to do it?
0
 
cyimxtckAuthor Commented:
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
 
TheVeeeCommented:
Then wouldnt you want to award the points to him vice closing the question?
0
 
cyimxtckAuthor Commented:
Perfect!
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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