No, I always use the sql script and then move the data through either dts or access or excel files depending on what the data is. The backup/restore process is good if hyou have access to the server's file system.
Tyler Clendenin GSL Solutions -----Original Message----- From: Matthew Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 4:09 PM To: CF-Community Subject: RE: help with mssql and EM They are not set to not replicate. The primary key property is also being dropped. Also, the tables have data in them I am trying to move online. The sql script won't transfer the data will it? Thank you though. -----Original Message----- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:05 PM To: CF-Community Subject: RE: help with mssql and EM The Identoty fields are prolly dropped because they are set as not to replicate. But really the best way to transfer sql tables is to go "All Tasks" -> "Generate SQL Script" Tyler Clendenin GSL Solutions -----Original Message----- From: Matthew Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 2:27 PM To: CF-Community Subject: help with mssql and EM When I upload my tables to crystal tech's sql server, the identity and primary key properties get dropped from the table. Why is this happening? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:133342 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54