|
|
 |
| Home » Forums » DBManager General |
|
|
| how to convert tsql script or stored procedure to msaccess script? (1490 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? (1490 previews) | |
Legends Topic has Replies Topic With no Replies
|
|
| Home » Forums » DBManager General |
|
|
Copyright © 2001-2024 dbTools Software. Best viewed with IE 7.x, Chrome or Firefox 3.x or higher at 1024x768 Register | Contact US | Forums | About US |