Home » Forums » DBManager General
 
how to convert tsql script or stored procedure to msaccess script? (1381 previews)
how to convert tsql script or stored procedure to msaccess script? Posted in 13th, 06/2006 04:43 by lvolovik
Hello,

I have access database and sql server the same structured database.
I wrote sql batch (or stored procedure) for sql server but I need to convert it into msaccess syntax.
Is it posible to do this kind of job by using DBManager tool and how?
Thanks,

luda /
Re: how to convert tsql script or stored procedure to msaccess script? Posted in 13th, 06/2006 04:55 by support
Hi,

This is not possible actually. The main reason is that MSAccess does not support Stored Procedures nor User Defined Functions which makes life even harder. What does this procedure do? Depending on the process executed by the stored procedure you can simulate most of the tasks by using the Task Builder in DBManager. It allows you to execute several SQL scripts to perform certain operations.

Best Regards,

Support / DBTools Software
Re: how to convert tsql script or stored procedure to msaccess script? Posted in 13th, 06/2006 05:26 by lvolovik
Hi,

Thanks for fast response!

This is .sql file with 80 DML queries transferring and modifying data from one database to another (both on the same sqlserver 2000) using all kind of joins, subqueries, "from" queries, etc.

Both databases exist in Access db too and the same actions should be repeated in Access environment.

I do not know access syntax and limitations of it.

I need some convertion tool because I have to do procedures like this all the time

Thanks,





luda /
Re: how to convert tsql script or stored procedure to msaccess script? Posted in 14th, 06/2006 09:44 by support
Hi,

If the process is converting and/or moving data from one engine to another than DBManager is the right way to go. For this to work you need to:

- Connect both engines
- Use the Migration Wizard, or
- Use the Task Builder to automate the process

If you only have the .SQL (DML) file than there is nothing that can fix that for you. You would be able to load it into a database, though, making it possible to after that, move the data to MSAccess or vice versa.

Best Regards,

Support / DBTools Software
RE: how to convert tsql script or stored procedure to msaccess script? Posted in 13th, 06/2018 04:55 by wq24783670
http://www.hollister.com.de/, http://www.nikefree5.com.co/, http://www.ralphlaurens-polos.co.uk/, http://www.timberland-shoes.net.co/, http://redskins.nfl-jerseys.org/, http://www.long-champ.com.co/, http://www.burberry-storevip.com/, http://www.nikeair-max.es/, http://www.hollister-clothings-store.com/, http://www.nike-store.com.de/, http://www.nike-maxshoes.fr/, http://panthers.nfl-jerseys.org/, http://www.givenchy.com.co/, http://chargers.nfl-jerseys.org/, http://nuggets.nbajerseyssale.com/, http://www.nfl-jerseys.org/, http://www.truereligions.net/, http://www.airhuarache-inc.co.uk/, http://www.toms--outlet.com.co/, http://www.coachoutlet-online.com.co/, http://www.uhren-stores.de/, http://azcardinals.nfl-jerseys.org/, http://pacers.nbajerseyssale.com/, http://www.burberryoutlet-sale.net.co/, http://www.chiflatiron-hair.com/, http://www.linksoflondonvip.com/, http://www.nikerosherun.com.co/, http://www.juicy-coutureoutlet.com/, http://www.airmax-shoes.com/, http://www.michael-korsbags.com.co/, http://www.swarovski-jewelrys.co.uk/, http://www.nikeshoes.mex.com/, http://chiefs.nfl-jerseys.org/, http://www.birkenstockshoes.com.de/, http://www.skechers-shoesoutlet.com/, http://thunder.nbajerseyssale.com/, http://www.chrome-heartsoutlet.com/, http://www.michael-kors.co.nl/, http://www.mizuno.us.com/, http://www.puma-shoes.com.de/, http://www.gucci-shoesoutlet.com/, http://www.timberland-boots.com.co/, http://www.burbagsoutlet.com/, http://www.uggs-boots.com/, http://jets.nfl-jerseys.org/, http://www.thenorth-face.com.co/, http://www.airjordans-shoes.com/, http://www.nike-shoes.org.es/, http://www.rayban-lunettes.fr/, http://www.rolexswatchoutlet.com/, http://www.long-champ.com.de/, http://www.airjordanshoes.com.co/, http://www.mizuno-running.net/, http://www.supra-footwear.net/, http://www.bottega-venetasoutlet.com/, http://www.hollisterclothingcanada.ca/, http://www.oakleysunglasses.org.es/, http://www.nikerosherun.com.de/, http://www.oakleys-outlets.net/, http://www.nbateamonline.com/, http://www.ray-bansoutlet.net.co/, http://www.danskos-shoes.com/, http://www.long-champ-outlet.com/, http://www.coachfactory.cc/, http://www.eyeglassesinsale.com/, http://www.coachblackfriday.com/, http://www.michael-kors-bags.com/, http://www.hollister-outlet.com/, http://www.toms-shoesoutlets.com/, http://www.under-armour.us.com/, http://www.scarpehogan-shoes.it/, http://www.cheap-iphone-cases.com/, http://www.raybans-outletonline.com/, http://www.nbajerseyssale.com/, http://www.true-religionsoutlet.com/, http://www.rosherun-shoes.us/, http://www.pandora-jewelry.com.de/, http://www.michaelkorspurses.co.uk/, http://magic.nbajerseyssale.com/, http://www.tracksuits.com.co/, http://www.cheap-pandora-charms.org.uk/, http://www.ralphlauren-au.com/, http://www.cheap-raybansunglasses.com/, http://www.oakley-outletonline.com.co/, http://www.cheap-watches.com.co/, http://www.montblancs.com.co/, http://bulls.nbajerseyssale.com/, http://www.raybansbocco.it/, http://www.coachoutletonlinemall.com/, http://www.nhljerseys.com.co/, http://www.kate-spades.net/, http://www.converses.us.com/, http://www.replicabags.net.co/, http://www.thomas-sabo.us.com/, http://www.designer-bags.us.com/, http://www.barbours-factory.com/, http://www.asicsshoes-outlet.com/, http://hornets.nbajerseyssale.com/, http://www.raybans-outlet.cc/, http://www.softballbats-sale.com/, http://www.michaelkors.com.de/, http://www.reebok-shoes.co.uk/, http://spurs.nbajerseyssale.com/, http://www.ralphslauren-polo.com.co/, http://www.nfljerseys-sale.com/, http://www.outlet-pradabags.com/, http://www.oakley-sunglassessale.com.co/, http://www.new-balanceoutlet.org/, http://www.ralph-laurenpolos.net/, http://www.converse-schuhe.com.de/, http://www.raybanoutlet.ca/, http://buccaneers.nfl-jerseys.org/, http://www.mcm-backpacks.com.co/, http://www.christian-louboutin.jp.net/, http://www.adidasshoes.com.se/, http://www.burberry-outlets.ca/, http://www.airmax2015.net/, http://cavaliers.nbajerseyssale.com/, http://suns.nbajerseyssale.com/, http://texans.nfl-jerseys.org/, http://www.tommys-hilfigers.net/, http://www.nikeairmax.com.de/, http://raptors.nbajerseyssale.com/, http://www.cheapnhljerseys.us.com/, http://www.raybans.com.de/, http://www.ralphslaurensoutlet.co.uk/, http://trailblazers.nbajerseyssale.com/, http://www.armaniexchange.us.com/, http://www.dsquared2-outlet.com/, http://www.rolex-watches.us.com/, http://rams.nfl-jerseys.org/, http://steelers.nfl-jerseys.org/, http://www.rl-ralphlauren-polos.co.uk/, http://lions.nfl-jerseys.org/, http://www.air-yeezyshoes.com/, http://www.skechers-canada.ca/, http://patriots.nfl-jerseys.org/, http://www.swarovski-canada.ca/, http://www.converse-shoes-outlet.com/, http://www.ralphlaurens-outlet.net/, http://www.nike-factory.com.co/, http://www.jimmychoo-shoes.com/, http://www.christian-louboutin-shoes.com/, http://www.salvatoreferragamo.us.com/, http://www.barbours.us.com/, http://www.barbour-jackets.in.net/, http://grizzlies.nbajerseyssale.com/, http://www.nikeshoesoutlet.co.nl/, http://www.woolrich-jackets.com/, http://www.parajumpersjacketsoutlet.com/, http://www.pandora-charmscanada.ca/, http://www.hogans.com.de/, http://www.rolex-watchescanada.ca/, http://www.versaceoutlet.us.com/, http://49ers.nfl-jerseys.org/, http://michaelkors.euro-us.net/, http://www.pandora-jewelrys.com/, http://www.montrespascher.fr/, http://www.coachoutlet.fr/, http://www.jerseys-store.com/, http://www.cheap-jerseys.mex.com/, http://www.hollister-store.com.co/, http://www.michaelkors.so/, http://pelicans.nbajerseyssale.com/, http://www.calvin-kleinoutlet.com/, http://www.chiflatironhair.us.com/, http://www.jimmychoos-shoes.com/, http://www.pandora-jewelry.top/, http://www.michaelkorsbagsvip.com/, http://www.nike-shoesoutlet.us.org/, http://www.adidassuper-star.com.de/, http://www.fendi-outlet.us.com/, http://www.burbsoutlet.co.uk/, http://www.sunglasses-outletonline.com/, http://coachoutlet.euro-us.net/, http://www.christianlouboutinoutlet.net.co/, http://www.nike-mercurial.com/, http://www.tommyhilfiger-outlet.net/, http://www.stone-islandestore.com/, http://www.asicsoutlet.net/, http://bengals.nfl-jerseys.org/, http://www.christian-louboutins.com/, http://www.eccoshoesoutlet.com/, http://www.raybans-cher.fr/, http://www.adidas-shoes.es/, http://www.belstaffjacketsoutlet.co.uk/, http://www.michaelkorsviponline.com/, http://www.fredperrypolos.co.uk/, http://www.toms-shoesstore.com.co/, http://www.northfacejackets.fr/, http://www.nike-shoesoutlet.com/, http://titans.nfl-jerseys.org/, http://www.hermesbags-outlet.com/, http://www.soccers-shoes.us.com/, http://www.louboutinshoes.jp.net/, http://www.new-iphonecases.com/, http://www.coach-outlets.net.co/, http://www.ralphlauren-canada.ca/, http://www.converse-shoes.net/, http://www.ralph-laurenoutlets.com/, http://www.longchamps-bags.us.com/, http://www.kate-spadebags.com/, http://www.northface-jackets.co.uk/, http://www.burberryoutletonline.com.de/, http://www.oakleysframesvip.com/, http://giants.nfl-jerseys.org/, http://www.philipppleinblog.com/, http://www.jerseys.net.in/, http://www.outlet-true-religion.com/, http://www.mcmshandbags.com.co/, http://heat.nbajerseyssale.com/, http://www.outlet-michaelskors.com/, http://kings.nbajerseyssale.com/, http://nets.nbajerseyssale.com/, http://www.nikefreerunshoes.com/, http://www.mbt-shoesoutlet.com/, http://www.belstaff-jackets.us.com/, http://www.rayban-wear.co.uk/, http://www.basketballshoes.com.co/, http://www.barbour-jackets.us.com/, http://www.lacoste-polos.us.com/, http://www.oakleysunglasses-canada.ca/, http://www.ray-bans.net.co/, http://www.co-aol.com/, http://www.the-northface.ca/, http://www.skechers-outlet.com/, http://www.australia-uggs.com/, http://www.giuseppes-zanottishoes.com/, http://colts.nfl-jerseys.org/, http://www.cheapjerseys-outlet.com/, http://www.coach-factoryoutlet.net.co/, http://www.ferragamo.net.co/, http://www.vans-shoesoutlet.co.uk/, http://jazz.nbajerseyssale.com/, http://www.katespades.com.co/, http://wizards.nbajerseyssale.com/, http://www.cheap-michaelkors.com.co/, http://seahawks.nfl-jerseys.org/, http://www.new-balanceshoes.es/, http://www.swarovskionlineshop.com.de/, http://vikings.nfl-jerseys.org/, http://www.salvatore-ferragamos.com/, http://eagles.nfl-jerseys.org/, http://coach.euro-us.net/, http://www.vibram--fivefingers.com/, http://www.polo-ralphlaurens.com.co/, http://www.newbalanceschuhe.com.de/, http://www.coach-outletonline.ca/, http://www.nikeroshe-run.com.es/, http://www.supra-footwears.com/, http://lakers.nbajerseyssale.com/, http://www.michaelkorsoutletvip.com/, http://www.airhuarache-shoes.co.uk/, http://www.cheap-mlbjerseys.us.com/, http://www.nike-paschers.fr/, http://www.polo-ralphlaurens.us.com/, http://www.tommyhilfigers.com.de/, http://www.retrojordan-shoes.com/, http://www.christian-louboutinshoesoutlet.com/, http://www.dsquared2s.com/, http://www.raybans-outlet.co.nl/, http://www.nikefrees-shoes.co.uk/, http://www.prada-shoes.us.org/, http://www.ralphlaurens.com.de/, http://www.valentinoshoes-outlet.com/, http://www.salomonshoes.com.de/, http://76ers.nbajerseyssale.com/, http://www.horlogesrolexs.co.nl/, http://www.asics-shoesoutlet.net/, http://www.australia-michaelkors.com/, http://www.outletburberry-bags.com/, http://www.michaelkorsoutlet.online/, http://bucks.nbajerseyssale.com/, http://www.nikeshoes-canada.ca/, http://www.jordan.com.de/, http://www.hugo-boss.com.co/, http://www.toms-outletonline.com.co/, http://www.nikefreerun-inc.co.uk/, http://www.timberland-boots.fr/, http://www.versaces-outlet.com/, http://www.coachoutletonline.vip/, http://www.newbalance-canada.ca/, http://www.polos-ralphlaurens.co.uk/, http://bears.nfl-jerseys.org/, http://www.mk-com.com/, http://www.thomas-sabos.com.de/, http://www.pradas.com.de/, http://www.ralphslauren-polo.com/, http://www.prada-outlet.net.co/, http://www.nikeairforce.com.de/, http://www.birkenstocks.com.de/, http://www.oakleys-sunglasses.com.co/, http://www.babylisspros.com/, http://www.belstaff-outlet.com/, http://www.hermesbagsoutlet.com/, http://www.nike-airmax.com.de/, http://www.bcbg-canada.ca/, http://www.outlet-tommyhilfigers.com/, http://www.cheapshoes.net.co/, http://www.michael-korsoutletonline.com.co/, http://www.outletonline-michael-kors.co.uk/, http://www.handbags-outlet.in.net/, http://www.tommyhilfigers.co.nl/, http://www.sac-hermes.fr/, http://www.barboursjackets.com/, http://www.nike-rosherun.co.nl/, http://www.toryburchs.us.com/, http://www.long-champhandbags.com/, http://www.gbyguess.us.com/, http://www.ralphlauren.mex.com/, http://warriors.nbajerseyssale.com/, http://www.michael-kors.com.es/, http://www.nikeairmax-australia.com/, http://www.rosherun-shoes.co.uk/, http://www.raybansoutlet.co.uk/, http://clippers.nbajerseyssale.com/, http://www.outlet-michaelkors-online.com/, http://www.oakley-outlet.fr/, http://www.outlet-pradas.com/, http://www.mcmbackpacks.com/, http://falcons.nfl-jerseys.org/, http://www.ray-bans.com.co/, http://www.michael-kors.net.co/, http://www.guccishoes.net.in/, http://www.cheap-juicycouture.com/, http://www.under-armouroutlet.com/, http://www.nike-huarache.co.nl/, http://www.coach-factorys.com/, http://www.levis-jeansoutlet.com/, http://www.cheap-raybansoutlet.com.co/, http://www.polos-ralphlauren.com.co/, http://www.coachoutlet-coachoutletonline.com/, http://www.oakleyssunglassesvip.com/, http://www.michaelkors-bags.co.uk/, http://www.cheap-omegas-watches.com/, http://www.the-north-face-jackets.com/, http://www.celinefactory.com/, http://www.mlbjerseys.com.co/, http://www.hollister-clothings.us.com/, http://www.outlet-true-religion.us.org/, http://www.cheap-timberlandboots.com/, http://www.coach-factory.com.co/, http://www.rayban-sunglasses.co/, http://www.jack-wolfskin.us.com/, http://www.hermes-birkinoutlet.com/, http://www.marcjacobs-outlet.com/, http://www.poloralphlaurens.com.de/, http://www.vansschuhe.com.de/, http://www.swarovskijewellery-au.com/, http://www.philipppleins.us.com/, http://www.nikeair-max.ca/, http://www.the-northface.in.net/, http://www.pandorajewellery.com.es/, http://www.coachoutlet-usa.com/, http://jaguars.nfl-jerseys.org/, http://www.ferragamo-inc.co.uk/, http://www.burbsbags.co.uk/, http://timberwolves.nbajerseyssale.com/, http://celtics.nbajerseyssale.com/, http://www.vansshoes-outlet.com/, http://www.true-religions.com/, http://www.replica-bagsoutlet.com/, http://www.airmax-90.com/, http://www.oakleys.com.de/, http://www.burberoutlet.com/, http://www.airmax.com.se/, http://www.nikeshoes.com.de/, http://www.adidas-shoes.ca/, http://www.outlet-ralphlauren.co.uk/, http://ravens.nfl-jerseys.org/, http://www.nike-airmax.in.net/, http://www.fred-perrys.co.uk/, http://www.polos-outletsstore.com/, http://www.oakestore.com/, http://www.mcm-bagsoutlet.com/, http://hawks.nbajerseyssale.com/, http://www.outlet-pumashoes.com/, http://www.ralphlaurens.com.co/, http://www.oakley-sbocco.it/, http://www.moncler-jackets.com.co/, http://www.nba-jerseys.com.co/, http://www.hoodiesoutlet.net/, http://www.the-northface.com.de/, http://www.the-north-face.com.co/, http://www.toms-shoe.us.org/, http://www.fitflop-outlet.com/, http://rockets.nbajerseyssale.com/, http://www.giuseppezanotti.com.co/, http://www.nike-skos.com/, http://www.nike-free-runs.de/, http://www.cheapmontblanc-pens.com/, http://www.canada-michaelkors.ca/, http://www.the-north-face.net.co/, http://www.michaelkorsbags-outlet.com/, http://www.oakleysoutlet.com.co/, http://www.ed-hardy.us.com/, http://www.soccershoes-outlet.com/, http://www.burberbags.com/, http://www.longchamp-outlet.com.co/, http://www.adidasschuhe-online.com.de/, http://www.raybansasses.com/, http://www.cheap-baseballbats.us/, http://www.oakleyframeslrc.com/, http://www.ferragamos.us.com/, http://broncos.nfl-jerseys.org/, http://www.oakleys-online.com.co/, http://www.marc-jacobs.com.co/, http://www.omegas-relojes.es/, http://www.hogan-shoesoutlet.co.uk/, http://www.nike-shoes-outlet.co.uk/, http://www.watch-rolex.co.uk/, http://raiders.nfl-jerseys.org/, http://mavericks.nbajerseyssale.com/, http://www.new-balanceshoes.com/, http://dolphins.nfl-jerseys.org/, http://www.air-maxschoenen.co.nl/, http://pistons.nbajerseyssale.com/, http://www.tommy-hilfigers.de/, http://saints.nfl-jerseys.org/, http://www.pandora-jewellery.com.es/, http://www.lacosteoutlet.com.co/, http://www.soccershoes.us.com/, http://www.zccoachoutlet.com/, http://www.oakleyslrc.com/, http://www.burberryhandbagsvip.com/, http://browns.nfl-jerseys.org/, http://www.ok-em.com/, http://www.adidas-shoes.com.co/, http://www.ray-bans.org.es/, http://www.rolexwatchesforsale.us.com/, http://www.oakleyssunglasslrc.com/, http://www.jackwolfskinoutlet.ca/, http://www.fidgetspinner.com.co/, http://www.outlet-toryburchshoes.com/, http://www.nba-shoes.com/, http://www.bcbg-dresses.net/, http://www.nike-shoes.com.co/, http://www.christian-louboutins.us.com/, http://www.adidas-shoesoutlet.com/, http://www.nike-shoes.com.se/, http://packers.nfl-jerseys.org/, http://www.adidas-shoes.co.nl/, http://www.birkenstock-shoes.com/, http://www.mcm-handbags.com.co/, http://www.ralph-laurens-polos.com/, http://bills.nfl-jerseys.org/, http://www.crystals-swarovskis.com/, http://www.cheap-jordans.com.co/, http://www.hollister.com.se/, http://www.tods-shoesoutlet.com/, http://www.thomassabos-jewelrys.org.uk/, http://www.monclers-outlet.us.com/, http://www.omegas-watches.com.co/, http://www.nikeairmax-isc.co.uk/, http://www.guessfactorys.com/, http://www.guci-heaven.com/, http://www.nikeairmax-shoes.fr/, http://www.christianlouboutin-shoes.ca/, http://www.jordan-retros.com/, http://www.kate-spade-outlet.us.com/, http://www.cc-beanies.us.com/, http://www.reeboks.com.de/, http://www.the-northfacejackets.net.co/, http://www.bottega-outlet.com/, http://www.tommyhilfigerca.ca/, http://www.burberrys-outletonline.in.net/, http://www.tomsshoes-outlet.us.org/, http://www.lonchamp.us.com/, http://www.jewelrys-swarovski.com/, http://www.michaelkorsoutlet.se/, http://www.burberry-store.com/, http://www.jeans-truereligion.com/, http://cowboys.nfl-jerseys.org/, http://knicks.nbajerseyssale.com/

wq123 / usa

how to convert tsql script or stored procedure to msaccess script? (1381 previews)
Legends

Topic has Replies
Topic With no Replies
 
Home » Forums » DBManager General