DB script with blank data - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

DB script with blank data

Author

Topic

swatib
Posting Yak Master

173 Posts

Posted - 2006-04-12 : 02:15:48

Hello All

I have a Database with data in all the tables in it.
I need to have DB script so that the same database with BLANK data is created on other server.
For that I generated DB script with 'Script All Objects' option along with the Security Scripting options -> Script Database and Table Scripting options -> all 4 selected.

Then I created a database on that other server and run the script in Query Analyser except the DB creation statements.

Did I complete the process or missed out anything

Your help is appreciated.

10x

Njoy Life

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-04-12 : 03:08:53

Following things will not be taken care in your case
1. JOBS, Alerts, Operators
2. DTS PACKAGES
3. Backup devices
4. Linked servers

And most important LOGINS! There is a chance of ORPHANED USERS.

------------------------
I think, therefore I am - Rene Descartes

swatib
Posting Yak Master

173 Posts

Posted - 2006-04-12 : 03:26:22

Thanks

One question- If I'm creating that database on other server then it will use that server's login, so why to have LOGINS of that previous server?

Please clarify this point

Njoy Life

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-04-12 : 03:42:35

quote:

One question- If I'm creating that database on other server then it will use that server's login, so why to have ....

That depends on who is going to access the DB after it has been moved to new server. Don't you want your old users to acccess the new server?

What you are saying is correct if, You don't want the old users to access the new server.

------------------------
I think, therefore I am - Rene Descartes

Kristen
Test

22859 Posts

Posted - 2006-04-12 : 03:43:05

Because the permissions on all the database objects will relate to the user who is logging in.

Unless everyone logs in as SA of course ... but that would be a really bad idea!

Kristen

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-04-12 : 07:45:35

no chance for orphaned users...

he is scripting out the database, so he needs to either script out the logins along with permissions and roles if any on the new database or just provide permissions/grant access if the logins exist

--------------------
keeping it simple...

swatib
Posting Yak Master

173 Posts

Posted - 2006-04-13 : 00:19:03

Yes, I don't want the old users to access the new server. As the database will have separate set of users for the other DB server.

Thanks

Njoy Life

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-04-13 : 02:22:37

quote:
Originally posted by swatib

Yes, I don't want the old users to access the new server. As the database will have separate set of users for the other DB server.

I really doubt whether you got what we are saying or not! But don't worry you will be enlightened as the posts increase....

------------------------
I think, therefore I am - Rene Descartes

Kristen
Test

22859 Posts

Posted - 2006-04-13 : 02:33:57

"I really doubt whether you got what we are saying or not!"

I thought that too ... but then I thought "Oh Well ..."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources