[cfaussie] Uploading databases to SQLServer 2005

2006-03-09 Thread Mike Kear
Has anyone succeeded in uploading databases to SQLServer2005 yet? I have the SQLServer2005 package we were given by Microsoft at WebDU, and I've installed it, and Im wading through the tutorials and help files, but in typical MS fashion, they arent simple step-by-steps, they are a series of

[cfaussie] Re: Uploading databases to SQLServer 2005

2006-03-09 Thread Antony Sideropoulos
Mike Have you tried the forums at www.sqlservercentral.com? They have a whole category for SQL Server 2005 Integration Services. Note - you need a (free) account to view the forums, but I've found them to be excellent in the past. HTH Antony On 3/10/06, Mike Kear [EMAIL PROTECTED] wrote:

[cfaussie] Re: Uploading databases to SQLServer 2005

2006-03-09 Thread Mike Kear
No (going to look right now). Thanks for your suggestion. Has anyone actually done what I'm trying to do? Surely it must be a common thing. No? CheersMike KearWindsor, NSW, AustraliaCertified Advanced ColdFusion DeveloperAFP Webworkshttp://afpwebworks.comColdFusion, PHP, ASP, ASP.NET hosting

[cfaussie] Re: Uploading databases to SQLServer 2005

2006-03-09 Thread Antony Sideropoulos
MSSQL2005 is pretty new... On 3/10/06, Mike Kear [EMAIL PROTECTED] wrote: No (going to look right now). Thanks for your suggestion. Has anyone actually done what I'm trying to do? Surely it must be a common thing. No? CheersMike KearWindsor, NSW, AustraliaCertified Advanced ColdFusion

[cfaussie] Re: Uploading databases to SQLServer 2005

2006-03-09 Thread Mike Kear
Thanks Dale, but i'm no a shared hosting envirnment in this job, and I dont have direct access to the backups. I have to ask teh support guy at one hosting provider to make a backup for me and email it to me (and support issues is the main reason i'm moving away), then upload that to the new

[cfaussie] Re: Uploading databases to SQLServer 2005

2006-03-09 Thread Joel Cass
Script the database, upload script, execute (You can execute through CFQuery with a little modification). I've done this for years using enterprise manager, I know things have changed, but something similar should be inSQL 2005? -Original Message-From: cfaussie@googlegroups.com

[cfaussie] Re: Uploading databases to SQLServer 2005

2006-03-09 Thread Mike Kear
That's what I said Joel. But it's not so. There is no such feature in SQLServer2005. You can't script it just like you did in Enterprise Manager. I used to get database details many ways in EntMgr, but they are all either well hidden or not available in the new version. You can do a whole bunch

[cfaussie] Re: Uploading databases to SQLServer 2005

2006-03-09 Thread Joel Cass
Hi, I just had a look at the "SQL Server Management Studio Express CTP" tool that I had installed a while ago and forgotten about, and there it is, right click on a database, go to tasks, select "generate scripts" and the wizard does the rest. Hope that helps Joel -Original

[cfaussie] Re: cfexecute linux problem

2006-03-09 Thread Gavin Cooney
thanks for all your suggestions yesterday. it turns out that the first bit of the command was an input, not an argument. so I ended up doing this: cfset arArguments = arrayNew(1) / cfset arArguments[1] = -c / cfset arArguments[2] = echo '\sum_{n=0}^\infty \frac{x^n}{n!}' |

[cfaussie] Flash remoting

2006-03-09 Thread Steve Onnis
when you call a service in flash remoting, does it work within the same instance of the service or does it create a new instance each time you call a method of the service? Steve --~--~-~--~~~---~--~~ You received this message because you are subscribed to

[cfaussie] Re: Flash remoting

2006-03-09 Thread Patrick Branley
im not sure but i would imagine each method call makes a separate http request of the server. as you need to specify onStatus and onResult handlers for the remote call. i think this is the point of frameworks like tartan implementing the command design pattern. this way you save up all your

[cfaussie] Re: Uploading databases to SQLServer 2005

2006-03-09 Thread M@ Bourke
Alarm bells are ringing here at AFPWebworks Central - our NEVER BE A PIONEER alarm is going off.Like someone else said be sure to check out the forums on sqlservercentral --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[cfaussie] Re: Flash remoting

2006-03-09 Thread Chris Velevitch
On 3/10/06, Steve Onnis [EMAIL PROTECTED] wrote: basically i am trying to set up a server polling process where one method is running and I can call another method to get its progress status If you weren't making a remoting call, how would you normally do this in CF? Chris -- Chris Velevitch

[cfaussie] Re: Uploading databases to SQLServer 2005

2006-03-09 Thread Mike Kear
Thanks Tom, Yes i have that tool. It's the one where the tools menu has vanished and i dont know how to get it back. It can't work teh same as your mySQL tool because Microsoft Improved the table/data transfer mechanism, dropping DTS, which no longer works in SQLServer2005 infavour of a new