SQL Server 2008 Import Data
-
hi all, i use a sql server 2008 import data, to import my database from access, but my access database always change because my application work over it. i want a way to make sql server 2008 import data to work automatically as the changes of the access database. please help me, if you know any way to create the automated import data from sql server 2008 thanks all
-
hi all, i use a sql server 2008 import data, to import my database from access, but my access database always change because my application work over it. i want a way to make sql server 2008 import data to work automatically as the changes of the access database. please help me, if you know any way to create the automated import data from sql server 2008 thanks all
-
hi all, i use a sql server 2008 import data, to import my database from access, but my access database always change because my application work over it. i want a way to make sql server 2008 import data to work automatically as the changes of the access database. please help me, if you know any way to create the automated import data from sql server 2008 thanks all
Your requirement does not state whether the SQL database is updated from multiple access databases or your application can update both the access (single use, disconnected) and the sql database when linked to the server/network. This dictates quite different solutions.
Never underestimate the power of human stupidity RAH
-
hi all, i use a sql server 2008 import data, to import my database from access, but my access database always change because my application work over it. i want a way to make sql server 2008 import data to work automatically as the changes of the access database. please help me, if you know any way to create the automated import data from sql server 2008 thanks all
If you have the time to make modifications, you can change the access database into an access project database. In access project, the data is not stored in access rather the data is stored to SQL Server. The project database just lists database objects(tables, views and stored procs)
-
hi all, i use a sql server 2008 import data, to import my database from access, but my access database always change because my application work over it. i want a way to make sql server 2008 import data to work automatically as the changes of the access database. please help me, if you know any way to create the automated import data from sql server 2008 thanks all
SQL Server comes with "SQL Server Integration Services" which is commonly referred to as SSIS. One commonly uses SSIS for data migration tasks. A very general outline of your solution would involve. 1. Create the migration task. 2. Schedule it so it runs repeatedly. The following is a tutorial which which teaches SSIS basics as well as creating a data migration task. http://technet.microsoft.com/en-us/library/ms365330.aspx[^]