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

How to load tables(with data) and dependent objects from DB to the other ? Expand / Collapse
Author
Message
Posted Tuesday, December 18, 2012 2:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 4:14 AM
Points: 38, Visits: 198
hello All ,
Can someone suggest me how I Can load tables and its dependent objects from one DB to the other DB dropping tables in old ones after successfully verifying both the Db's are in same server . I think i can use import/export wizard is there any best way i can do it..I do not want to use any software to use other then that comes with Sql Server Ent version..
Thanks in Advance...
Post #1397623
Posted Tuesday, December 18, 2012 4:07 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:43 AM
Points: 882, Visits: 4,144
just script it out and select the option with data and all required dependency you want.
Its advisable to generate the script per object.
Also, better have two different script folder
1) object creation
2) data load
then you can script the things and put them in required folder


----------
Ashish
Post #1397674
Posted Tuesday, December 18, 2012 5:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 4:14 AM
Points: 38, Visits: 198
Hi ashish thanks for the reply...
can i have the steps please coz i dont see the option for with dataload and I am a newbee here..

Thanks
Post #1397723
Posted Tuesday, December 18, 2012 5:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 4:14 AM
Points: 38, Visits: 198
by the way we use sql 2k5
Post #1397724
Posted Tuesday, December 18, 2012 5:48 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:43 AM
Points: 882, Visits: 4,144
not sure it "script with data"option is in sql 2005 or not but you can just copy the backup and restore on any 2008 server. Script it out and the same script will be applicable for 2005 as well (if you still prefer on 2005)

----------
Ashish
Post #1397728
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse