Ill try again ------------------------------------------------------------------ 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 Chad Renando Sent: Wednesday, June 29, 2005 1:52 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Strange request for a SQL tool 2 Gig limit, and I believe I had a few hundred thousand records in some tables. Besides, it didn't sound like either limitation would apply in Mr. Scott's case. Chad who feels official calling guys Mr. On 6/29/05, M@ Bourke <[EMAIL PROTECTED]> wrote: > "One way I did it was export everything, combine it up in MS Access > (only 'cause I'm familiar with it and it's easy to play with the > Autonumbers), create a datasource from the new .mdb and then manually > insert the Access data into SQL." > > I thought access has something like a 20,000 row limit per table ? > am I correct or incorrect on this ? > > M@ > Who has no qoute for this message. > > --- > 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/ --- 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/
