I believe that all you do is copy the database files from your local test machine and then attach the files to your production database.
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Matthew Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 15, 2007 2:05 PM To: SQL Subject: Problem with Microsoft SQL Server Management Studio Express I am new to Microsoft SQL Server Management Studio Expresss. I have to use it because my new site on Crystaltech only supports MSSQL 2005 databases, which EM won't connect to. I need to copy tables from the local database on my development machine to the CrystalTech server. I can't figure out how to do it. CAn anyone point me in the right direction? I looked through help and all I could find was replication, which I shouldn't need to set up. I just want to copy the database once. Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2907 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
