G'day Maureen, Glad to see someone's still here! I'm having problems moving my dev machine from SQLServer2005 (express edition) to SQLServer2012 Business Intelligence. Every week I have to update a client's online database with this weeks data. In the past I've gone a long way around it by using the Database Publishing Wizard to drop the relevant online tables and rebuild and populate them with the new data. Long way round, but good old sql works reliably and with SQL2005Express as my dev machine it's the only way I could find to do it.
But how to do the same job if my dev machine has SQLServer2012 is proving to be a problem. There doesn't seem to be an equivalent to Database Publishing Wizard. The 2012 SSDT data tools wont work (Visual Studio gives error saying SSDT has to be installed by the SQLServer2012 Standard, Enterprise, Developer or Evaluation versions. In other words, every other version of SQLServer2012 except Business Intelligence.) so I can't use SSIS either. How can I transfer data back and forth between my clients' SQL2005 online databases and my dev SQL2012 machine? Cheers, Michael Kear, Windsor, NSW, Australia AFP Webworks -----Original Message----- From: Maureen [mailto:[email protected]] Sent: Sunday, 4 November 2012 3:37 PM To: sql Subject: Re: Check one two Don't tap the microphone. You will dislodge the screen. Whatcha need? On Sat, Nov 3, 2012 at 8:37 PM, Michael Kear <[email protected]> wrote: > > Tap tap tap . is this thing on?? > > Mike Kear > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3451 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
