Easy way? And yes, i have had problems also doing it with DTS
Easiest way I have found is back the database up and restore it on the new server........ or............ copy the LDF and MDF files and transfer them to the new server, put them in the DATA directory of the new SQL server and use the "ATTACH" method of adding the database into the SQL server If you have foreign keys in your tables and you dont maintain the primary keys, the copying of data will fail. If your on a network, the ATTACH method will probably work well when moving from staging to production aswell cause you can run a script to detach the old database, if its there, copy the new database across and re attach it. If you are going to use DTS, then make sure you deselect the "Copy object level permissions" and "copy logins" options when your setting it up. If the permissions are not exactly the same then its going to fail. Regards Steve Onnis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Taco Fleur Sent: Wednesday, June 29, 2005 7:29 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Strange request for a SQL tool Uuuh, DTS copies them for you one at a time. I'm telling you DTS will do the trick but if you are not willing to have a look at it and investigate then go ahead and waste your time doing it manually. > Taco, > > To copy data from one table to another one at a time is not an option, I > require something that will automate this for me. If it was one or 2 tables > I wouldn't care and do the damn thing manually. > > I need a tool that will copy the data to another database, not copy the ID > field but if need be change the ID field that is other tables use as a > relationship. > > And yes that is where the constraints come in, this has bee setup to do this > for me. But I need to be able to import this data into the new database > renumber the identities and the constraint (via diagrams) should do the work > of making the other changes for me. > > Regards > Andrew Scott > Analyst Programmer > > CMS Transport Systems > Level 2/33 Bank Street > South Melbourne, Victoria, 3205 > > Phone: 03 9699 7988 - Fax: 03 9699 7976 > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur > Sent: Tuesday, 28 June 2005 4:30 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Strange request for a SQL tool > > You can also disable check constraints with DTS (I believe). > If not, then you just need to make sure you run the export in the right > order, i.e. > the tables with the foreign relationships first. > example; > > Person > User > Email > > First insert the Person because the User table relies on a record being > present > in the Person table etc. etc. > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to leave-cfaussie- [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ ________________________________ Taco Fleur - E-commerce Development Manager Shelco Searches & Services An Authorised ASIC Information Broker www.shelco.com.au Ph: + 61 7 3236 2605 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
