473,320 Members | 1,854 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to migrate database from MS Access to Sql Server?

Migrate database from MS Access to Sql Server.

I want to convert MS Access database to SQLServer completely. I don't want to keep MS Access more in use.
Converted New database will be using only sqlserver.

Using this I will be Developing Dotnet application.

help please.....
Feb 9 '11 #1
1 1236
ADezii
8,834 Expert 8TB
Look into SQL Server's Data Transformation Services under Import and Export Data.
Feb 9 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

49
by: Relaxin | last post by:
It is just me or has MS created some of the worst ways to access and display data? You can use a DataSet, but if you want to sort or filter the data to must use a DataView which is created from...
0
by: Ian | last post by:
hi i have a problem with database access (SQL Server/MSDE) on my production server. the asp.net web app works fine in test. on the production server, it won't connect to the database! ...
4
by: Shawn H. Mesiatowsky | last post by:
I have a strange problem here. I have my development computer with IIS installed, and we have a SQL server as well on a windows 2000 server. both are members of a domain. I have restricted access...
2
by: keithgell | last post by:
I needed to import large CSV files into Access, when requested by a command in a .Net interface. Because Access does not have a bulk insert command, and I already have vba macros in Access that...
0
by: DavidG | last post by:
I'm migrating a legacy intranet site from an IIS5 to IIS6 server. The site uses ActiveX DLLs to access a SQL database. The problem is that everything runs fine when hitting localhost from the...
1
by: Mike Cook | last post by:
The scenario is that i have one server but due to the number of users in 3 countries and the amount data it runs slowly What i want to do is to install another server , both servers will be the...
7
by: =?Utf-8?B?Um9nZWxpbw==?= | last post by:
hey, I have 2 threads, th and th2, both of them run a method. each of these 2 methods requires database access. sometimes I get an error, that database requires an open connection, and that...
3
hariharanmca
by: hariharanmca | last post by:
Subject : I want to Connect Flash with Database ('Access' or 'Sql Server' or some Idea). My tool is to create a form desigen (Login Register) in flash and connect it to database. It will...
1
by: adrian_alek | last post by:
HI I have to servers(windows) one I have DB2 v7.2 in the second I have DB2 8.2 with CM I have to migrate from the old version to the new version I read a lot of mail most of then say user...
2
by: berilker | last post by:
I have a project. I have to build a client server application and i have to access(and run some queries) to ms sql database which is at server side, from client application. How can i build this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.