Copiar table con objetos (SQL) con scripts

Javier Santillan 21

Good! How are they?

I need to copy several tables from one base to another (without the data but with the objects in the table)
I cannot use the Scripts Table to generate the scripts automatically and I proceeded to copy the tables with SELECT * INTO, but I would be missing the objects in the table such as indexes and triggers.
I am using SQL 2008 R2.
Any ideas?

CathyJi-MSFT 22,346 Reputation points Microsoft Vendor

2022-10-17T06:36:02.887+00:00

Hi @Javier Santillan ,

Any update for this thread? Did the reply could help you? If a response helped, do "Accept Answer". If it is not, please let us know. Your contribution is highly appreciated.

Accepted answer

CathyJi-MSFT 22,346 Reputation points Microsoft Vendor

2022-10-14T03:37:58.84+00:00

Hi @Javier Santillan ,

Agree with Olaf, suggest you using generate scripts wizard as below screenshots. In addition, suggest you use a newer version SSMS. You can get SSMS 18.12.1 from here.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Olaf Helper 45,811 Reputation points

2022-10-13T12:33:00.46+00:00

I am using SQL 2008 R2.

That version is out-of-support since a long time.

Anyway, in SSMS do a right-mouse click on the database => Tasks => Generate scripts ...
In the wizard you can select which object (type) you like to script out.
See Generate Scripts (SQL Server Management Studio)
Please sign in to rate this answer.
Javier Santillan 21 Reputation points

2022-10-13T13:32:02.683+00:00

Hello! OlafHelper-2800. First of all, I appreciate the answer, but I already tried it and I can't generate a script.

Erland Sommarskog 116.4K Reputation points MVP

2022-10-13T21:26:09.263+00:00

And what more precisely do you mean by that? What holds you back? Error message? Is the boss looking over your shoulder and say "don't do that"? Something else?

Sure, I've probably written queries to perform tasks like this, but I don't have them around. And Generate Scripts is probably the best option for a regular user.

Olaf Helper 45,811 Reputation points

2022-10-14T04:52:23.27+00:00

I can't generate a script.

Sorry, but no one can work on this reply; why can't you? Don't you find the context menu?
You use SQL Server 2008 R2, so I guess you use old SSMS for 2008R2 as well, isn't it?
Uninstall it and install the latest version from Download SQL Server Management Studio (SSMS)
That tool version support still older SQL Server versions, even if they as it are not supported.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Copiar table con objetos (SQL) con scripts

1 additional answer

Your answer