Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server problem! Expand / Collapse
Author
Message
Posted Wednesday, August 3, 2005 12:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 20, 2005 5:23 PM
Points: 5, Visits: 1
Good day, my name is nicholas, a newbie of SQL Server 2000, currently, got a question to ask, please kindly help!

Currently, i already created 87 tables in SQL Server 2000 Developer Edition (in my PC), then, can i know is there any method to "copy & paste" all these 87 tables or "copy & paste" the whole database to the SQL Server 2000 Standard Edition (in a server)?

i already try the "Generate SQL Script", but since like i am in the wrong steps already~! Thus, please kindly help me, teach me or show me some instructions, MANY THANKS!

best regards,
Nicholas
Post #206704
Posted Wednesday, August 3, 2005 7:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 2, 2013 2:46 PM
Points: 392, Visits: 82
The best method for this is to take a backup of your development database and restore the backup file into production.
Post #206842
Posted Wednesday, August 3, 2005 7:35 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 8:11 AM
Points: 3,244, Visits: 529

another method is to detach the database, copy the .mdf and .ldf files to their new location and then attach them.

-SQLBill




Post #206858
Posted Wednesday, August 3, 2005 4:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 20, 2005 5:23 PM
Points: 5, Visits: 1
are u means right click the database, select "All Task" -> then "Back up Database?

is it means that if i can find the .mdb & .ldf together, then wht u means of "ATTACH" them?

Thanks for ur help~!
Post #207137
Posted Wednesday, August 3, 2005 9:08 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 9:37 AM
Points: 2,553, Visits: 567
Rats - I just spent the last half an hour typing out the various steps - only to have the whole text "vanish" - ctrl z isn't bringing it back to life either

at any rate - jason hall's method:

click on the wizard icon (the magic wand) on the tool bar of enterprise manager, go to "management" - "backup wizard" - it'll walk you through all the steps - copy the backup file which will be saved with a .bak extension in your backup folder - save it in a folder in your target server - create a brand new database in the target server - - and right click - select "all tasks" - "restore database" - "from device" - "select devices" - "add" - navigate to saved .bak file and open - say "ok"

sqlbill's is to right click - select "all tasks" - detach database - go to the data folder which will have saved your data and log files with an .mdf and .ldf extension - copy these files - and then "attach" them in the target server. However, if you're new to all this - my suggestion would be to do it Jason's way - it's easier to follow!

A third way - if you have only created the tables but not populated it with any data - is to right click on one of the tables - select "all tasks" - "generate sql script" - "show all" - and under the options tab - select either "create one file" or "create one file per object" - then you can copy this/these file/s and run the script in the query analyzer (after having created a new database in the target server).

Use BOL (books on line) for help and guidance regardless of the method you choose. Everything seems difficult when it is new but with practice you'll be surpised how easy and effortless it all becomes. Good luck!








**ASCII stupid question, get a stupid ANSI !!!**
Post #207176
Posted Thursday, August 4, 2005 7:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 27, 2010 5:17 AM
Points: 104, Visits: 3

THANK YOU SUSHILA!!!

>>Rats - I just spent the last half an hour typing out the various steps - only to have the whole text "vanish" - ctrl z isn't bringing it back to life either  <<

I have had this happen several times and have yet to figure out why.  I've taken to saving my reply in Notepad before clicking "Post Reply" or "Preview."  This is an irritation, but not as bad as losing several minutes of work (and carefully crafted brilliance ).

Post #207323
Posted Thursday, August 4, 2005 7:25 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 9:37 AM
Points: 2,553, Visits: 567
I keep meaning to do this (type response in Notepad) but suffer from memory lapses everytime!

I'm not sure why I'm being thanked - is it because I confirmed for you the fact that you needn't have been rubbing your eyes out off your head everytime your (carefully crafted brilliance) turns out to be apparitional ?!?!?!








**ASCII stupid question, get a stupid ANSI !!!**
Post #207334
Posted Thursday, August 4, 2005 8:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 27, 2010 5:17 AM
Points: 104, Visits: 3

I thank you for confirming the event.  I thought I was just experiencing premature 'old timers' disease and losing my way around the form.  This is an inconsistent, irritating, recurring problem.   I would love to take the time to figure out what is going on, but as we all know, time is in short supply in our field these days.  Hence the long diatribe and the continued popularity of this forum!

I love your refreshing use of 'apparitional.'  Proficiency in and appreciation of grammar, syntax, and non-technical vocabulary is somewhat rare in IT. 

Happy days.

 

Post #207365
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse