January 10, 2003 at 12:31 pm
What is the best way to make a copy of a
database on another server. I don't want the data.Only tables,procedures,views, (schema)..also user rights.
The database will also have a different name
on the other Server. Have tried scripting but
there are problems with dependencies, logins etc .
January 10, 2003 at 2:38 pm
Personally I'd stick with a simple solution if I could.
backup/restore.
Script the deletion of all data.
Steve Jones
January 13, 2003 at 2:52 am
I create script files for all my objects and therefore can create the database anywhere with any name.
If I want to transfer like you do then I do the following
Create new database
Create logins in new database same as old database making sure sid id the same
Transfer all objects between databases except data (change transfer options to transfer everything except logins)
I have done this several times with no problems so far.
Far away is close at hand in the images of elsewhere.
Anon.
January 13, 2003 at 8:57 am
where do you change transfer options to transfer everything except logins ?
This is all under copy objects ..right ..?
January 13, 2003 at 9:58 am
Why not to make it simple:
In EM right click the database to be scripted, All tasks, Genarate SQL script.
And there you choose the options you want to script.
Simple, fast except for a large number of objects!
I have SAP with comes with his 25000+ tables + SP + views... so it blows up the memory of my machine by feeding the list box.
But for a few hundres of objects it works fine.
Bye
Gabor
January 13, 2003 at 12:56 pm
Forgot to mention I use SQL7 don't know if SQL2000 is the same or not!!!!
In SQL7
under 'Select Objects to transfer'
uncheck 'Use default options'
click on 'Options' button
if you select 'Transfer SQL Server logins' then ALL THE LOGINS ON THE SOURCE SERVER will be transferred to the destination server.
if you select 'Transfer database users and database roles' then all the users and roles for the source database are transferred to the destination database.
make sure to select 'Transfer object-level permissions' in any case so that permissions are transferred.
nyulg's suggestion is a good one. I forgot about scripting. This way you have the script for later use. The options are the same behave in the same way (eg all logins are scripted) but you can edit the script before executing.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply