How to run the scripted database in a new server database

nector

Member
Local time
Today, 17:16
Joined
Jan 21, 2020
Messages
521
I have scripted the entire database with a believe that the script copied all the objects. Now how do I run the script in the new server sql database, below the attached scrprit.
 

Attachments

I have scripted the entire database with a believe that the script copied all the objects. Now how do I run the script in the new server sql database, below the attached scrprit.
Nector,
What generated the script?
For most of it. You could run it in SSMS from the master database.
The embedded \r \n stuff makes it seem the file originated from a Unix system/utility.
Otherwise, the database can't exist on the server where you run the script.
The datatype nvarchar really makes as though the original database was made through a utility and still needs some work.
Tough typing on a phone.
Wayne
 

Users who are viewing this thread

Back
Top Bottom