>- see footer for list info -< Yes, backup the database and send it over to be restored on the SQL server.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Aidan Whitehall > Sent: 11 December 2004 12:42 > To: [EMAIL PROTECTED] > Subject: [CF-Dev] OT : Access to SQL Server ballache > > >- see footer for list info -< > This has got to be easier than it appears. A friend has an > Access db (handful of tables with just data, no constraints, > etc) on his workstation and a hosting package which comes > with SQL Server. He can't connect to SQL Server remotely, but > can upload ".sql" files to the server. I've got a copy of > MSDE running here and to help him out, figured it would be a > piece of the proverbial to run the Access upsize into MSDE, > then use some Enterprise Manager built-in functionality to > spit out the data in one ".sql" file. > > Well, now it's in MSDE, it's easy enough to export the schema > using EM and get a ".sql" file with the necessary commands to > recreate the structure, but it doesn't contain the data. > > If I go down the Export Data... Route and use DTS > Import/Export Wizard, and select an SQL Server > Text file > route, the text file just contains the data, without the > required SQL statements to execute to import that data at the > other end. And, boning up on "bcp", it doesn't seem to > provide an option that allows you to dump the data with the > required SQL to import it at the other end either. > > Please tell me there's an easy way to do this? > > > -- > Aidan Whitehall [EMAIL PROTECTED] > Macromedia ColdFusion Developer > Fairbanks Environmental +44 (0)1695 51775 > > ______________________________________________________________ > __________ > This e-mail has been scanned for all viruses by Star. The > service is powered by MessageLabs. For more information on a > proactive anti-virus service working around the clock, around > the globe, visit: > http://www.star.net.uk > ______________________________________________________________ > __________ > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving > lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to > volunteer your help > >-< > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
