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 Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Mike Kear
Sent: Friday, 10 March 2006 1:53 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Uploading databases to SQLServer 2005That'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 of scripting and visual programming with it, but as I said, I'm up to part 9 after 5 hours and still no sign of how to do this task, which I would have thought was a pretty basic need.I even tried using the freeware EMS SQL Manager lite, and there's an Extract database feature in that, but not in the full version. But to invoke the extract database wizard, you have to use the Extract Database wizard from the Tools/Extract Database item on the menu. However there is no TOOLS menu and after looking around for an hour now I can't find where a Tools menu might be hiding. There's no FIle/Edit/View etc menu bar on this.
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On 3/10/06, Joel Cass <[EMAIL PROTECTED]> wrote: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 in SQL 2005?-----Original Message-----
From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Mike KearSent: Friday, 10 March 2006 1:36 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Uploading databases to SQLServer 2005--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
- [cfaussie] Re: Uploading databases to SQLServer 2005 Joel Cass
Reply via email to
