I have experienced errors sometimes copying objects using dts ususlly occurs when copying security settings, if its is ok and u want to get just the data and structure across you can try unchecking the use default options checkbox in step 4 of the DTS and click on the options button and uncheck all the security settings options and try running.
Another way would the backup and restore method if you have access to both servers and can ftp which I guess u do not have... Does double clicking on the error show up any details? -----Original Message----- From: Ross Williams [mailto:[EMAIL PROTECTED] Sent: 28 November 2003 18:43 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views Hi Paul, Thanks for that - but still getting the error with the scripting. I tried it the traditional way (hadn't seen that before) and right at the end, in prick tease manner, it pops up: "1 task(s) failed during execution." The step shown is "Copy SQL Server Objects Task: undefined", with the status shown as "Error Occurred". Is there any other way of getting a database from one server to another!?? R ------------------------------------------------------- RAWNET LIMITED - Internet, New Media and ebusiness Gurus Visit our new website at http://www.rawnet.com for more information about our company, or call us anytime on 01344 393 040. ------------------------------------------------------- Ross Williams Managing Director, Rawnet Limited Direct Phone : +44 (0) 1344 393 440 Switchboard : +44 (0) 1344 393 040 ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. ------------------------------------------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 November 2003 18:35 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] MS SQL Enterprise Manager - Importing Views Ok views should be fairly straight foward with DTS - - how to - with DTS Right click on the database, under All Tasks, click export data. Provide the source and destination database info and then select the option "Copy objects and data between SQL Server databases". In the next window you might want to leave everything default if you want all the objects to go thru (SP's, views, user logins and all). Once you click next you might want to Save the DTS package. Now hit next with the run immediately checked. It might take sometime depending on the size of your database. Now the traditional way of doing the same: Ok if you have Enterprise Manager, click on the Server name and you will find DTS (the next item to Databases). Click on it, then right click on local packages, and click new package. Once it opens the new package, click on Task menu and click on Copy SQL Server objects task. Specify the source and destination database info and then move onto the copy tab. If you want to move the entire database with user logins, SPs, triggers, views, you might just want to leave everything to default and click ok. ** Then you click on the green button for execute and voila your database is transferred. Hope that helps. - Paul ----- Original Message ----- From: "Ross Williams" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 28, 2003 6:27 PM Subject: RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views > Hi Steve, > > Tried that - it scripts them okay, but bums out after about 5% of > copying them. > > Haven't used MS-SQL for years and now remembering why!! :o) > > R > > > -----Original Message----- > From: Steve Martin [mailto:[EMAIL PROTECTED] > Sent: 28 November 2003 16:31 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] MS SQL Enterprise Manager - Importing Views > > Import all entities as objects as opposed to "copy tables" > > > -----Original Message----- > > From: Ross Williams [mailto:[EMAIL PROTECTED] > > Sent: 28 November 2003 16:16 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] MS SQL Enterprise Manager - Importing Views > > Importance: High > > > > > > Hey hoo, > > > > Just getting back in with MS SQL Enterprise Manager - have run an > > import from one live database to another and it's imported all of my > > Views into the Tables. > > > > Has anyone come across this? I can see the Views in the Tables > > listing when they should be in the Views listing. > > > > Does anyone know how to rectify this or import differently? > > > > Many thanks, > > > > Ross > > > > > > ------------------------------------------------------- > > RAWNET LIMITED - Internet, New Media and ebusiness Gurus > > > > Visit our new website at http://www.rawnet.com for more information > > about our company, or call us anytime on 01344 393 040. > > ------------------------------------------------------- > > Ross Williams > > Managing Director, Rawnet Limited > > Direct Phone : +44 (0) 1344 393 440 > > Switchboard : +44 (0) 1344 393 040 > > ------------------------------------------------------- > > This message may contain information which is legally privileged > > and/or confidential. If you are not the intended recipient, you are > > hereby notified that any unauthorised disclosure, copying, > > distribution or use of this information is strictly prohibited. Such > > notification notwithstanding, any comments, opinions, information or > > conclusions expressed in this message are those of the originator, > > not of rawnet limited, unless otherwise explicitly and independently > > indicated by an authorised representative of rawnet limited. > > ------------------------------------------------------- > > > > > > -- > > ** Archive: > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] For human > help, e-mail: [EMAIL PROTECTED] > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] For > human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
