Oh I actually used the first option all the time which is "Copy tables and views from the source database".
I will try this option next time and see how it goes. > Look at DTS (in SQL Server Enterprise Manager) for server-to-server > object copying. This can move tables (w/ indexes) and data (if you > want it to). The simplest way to invoke it is to right-click on a > database and select the All Tasks/Export option. > Mark > > -----Original Message----- > From: Asim Manzur [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 28, 2004 2:32 PM > To: CF-Talk > Subject: OT- SQL copy over > > > I have two SQL servers (DEV and LIVE) > > Whenever I need to change something in SQL I do first on DEV then I > got the approval from client and then I copy over all the tables from > one to another. > > Is there any easiest way that I can run the query which radomaly take > all the table from DEV and COPY OVER to LIVE. > > The thing is I want to copy the exact same structure and primary keys > and all that (Exact same copy From DEV to LIVE) > > is there any tool available for that. > > thanks > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182870 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
