Link to home
Start Free TrialLog in
Avatar of hidrau
hidrauFlag for Brazil

asked on

How can I get the entire database script?

Hello guys

I need to get all tables, views, store procedures, functions etc from my Database to run it in another database placed into another machine.

How can I do that?

thanks
Alexandre
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hidrau

ASKER

Sorry my mistake when I wrote. Another server
have you tried to script it?
Ok same database on another server.

Then both remarks are valid, just generate scripts as 'create to' not like 'drop and create'

Sql toolbelt does the same but easier to control.
Avatar of hidrau

ASKER

Éric, I am trying right now.

I didn't know that was possible with SSMS
Avatar of hidrau

ASKER

Thanks a lot for your help