On 8/15/07, Matthew Smith <[EMAIL PROTECTED]> wrote: > 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. >
It seems like Express is limited in the import/export capability...you may need to use the full version of Management Studio for that (or another db management utility....I'm partial to Aqua Data Studio). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2908 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
