gastao Posted February 19, 2013 at 03:24 AM Report #496099 Posted February 19, 2013 at 03:24 AM boas precisava de uma ajuda tenho uma base de dados em mdb e queria converter para SQL de forma exacto com os dados que la estao e tudo isso e possivel?? alguem me consegue dar uma ajuda??
pt_V1p3r Posted February 19, 2013 at 12:03 PM Report #496119 Posted February 19, 2013 at 12:03 PM Exporta para csv e depois importa no sql, ou entao directamente no management studio fazes a importação do mdb e transformas as colunas e tabelas como queiras...
gastao Posted February 19, 2013 at 12:40 PM Author Report #496125 Posted February 19, 2013 at 12:40 PM queria fazer uma aplicaçao que me fizessse directamente....
Caça Posted February 19, 2013 at 02:13 PM Report #496138 Posted February 19, 2013 at 02:13 PM Se queres ser tu a fazer a migração, utiliza o SQLBulkCopy http://www.jorgepaulino.com/2010/01/vbnet-classe-sqlbulkcopy.html Pedro Martins Não respondo a duvidas por PM
gastao Posted February 19, 2013 at 03:13 PM Author Report #496158 Posted February 19, 2013 at 03:13 PM sabes se com o sqlbulkcopy as relações tambem passam?
Caça Posted February 19, 2013 at 03:17 PM Report #496159 Posted February 19, 2013 at 03:17 PM Não passam Pedro Martins Não respondo a duvidas por PM
gastao Posted February 19, 2013 at 03:23 PM Author Report #496163 Posted February 19, 2013 at 03:23 PM pois era o que eu calculava, eu precisava de algo que me migrasse de mdb to sql exactamente igual relaçoes, tabelas, dados...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now