Moving Access Database To Sql Server

Hi folks

I want to move Access database to Sql server but I don't want to use Import/Export Wizard. I want to use DTC Designer.

When I tried to do it I can move only one table between Access and Sql db for every connection.

So, what should I do?

I want to move some tables e.g. ten tables to temp db and then I want to put P.K and Uni. constraints on the main tables then move them and the rest of the tables to the currect destination database.

Did DTC Designer help me on this or should I use Import/Export Wizard.

Thanks guysI would use the Import Wizard or the appropiate Upsizing wizard in Access if applicable for your version of Access.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks for reply

The issue here that Access database contain data not correct. Due to

wrong data, I have to repair them before moving

it. Therefore, I have to design a temporary database and then set the conditions

on the database. The issue here I want to build DTS that move strong entity and

check the data and the conditions. When an error occurs, I want DTS to primate a

message to correct the data manually.

Can you give me any suggestion?

Thank you

|||Thank all for answring

I Moved data by using standard SQL statment

Select , Insert .....

Thnaks

Bye

Moving Access Database To Sql Server

Hi folks

I want to move Access database to Sql server but I don't want to use Import/Export Wizard. I want to use DTC Designer.

When I tried to do it I can move only one table between Access and Sql db for every connection.

So, what should I do?

I want to move some tables e.g. ten tables to temp db and then I want to put P.K and Uni. constraints on the main tables then move them and the rest of the tables to the currect destination database.

Did DTC Designer help me on this or should I use Import/Export Wizard.

Thanks guysI would use the Import Wizard or the appropiate Upsizing wizard in Access if applicable for your version of Access.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks for reply

The issue here that Access database contain data not correct. Due to

wrong data, I have to repair them before moving

it. Therefore, I have to design a temporary database and then set the conditions

on the database. The issue here I want to build DTS that move strong entity and

check the data and the conditions. When an error occurs, I want DTS to primate a

message to correct the data manually.

Can you give me any suggestion?

Thank you

|||Thank all for answring

I Moved data by using standard SQL statment

Select , Insert .....

Thnaks

Bye

Move VistaDB tables/data to SQL Server 2005

Is there any way to import a VistaDB database into SQL Server? From what I can tell, there is not...

Please advise.

Thanks,

MC

Try asking this in the Data Access forum. I think once you have a way to access the data, you can start working with SSIS. Or work with the VistaDB folks... :)

If you can get data out of VistaDB and into files or something, then SSIS can help you. Even better if there is ODBC or OLE DB access.

Move or delete file after uploading via SQL2k DTS Package

I have scheduled a DTS package (once a day) to open and import data from a fixed field file which is sent to our server via FTP from a data service bureau. The problem is that yesterday's file ends up remaining in the same location, while the new file being delivered by the service bureau via FTP does not over-write yesterday's file -- the file is added with a new reference...

Example:
Yesterday's file name "CLM_CLI.789" -- Today's file name "CLM_CLI.6890". Is there any way for SQL2k to delete the file after it is uploaded, or can anyone offer advice about how to use some other method to move the older file to another folder each day??

Thanks!
GlenHow does the DTS package know the name of today's file name?

I think you should be able to use xp_cmdshell to move the file to another directory.

Terri

Move DTS package to another server

I'm building a DTS package on my development server which I want to
move to my test server. I can save the file and import it, but there
are connections etc that will be named differently.

Is there a quick and easy way of changing the names of connections ? I
also have some CSV files used for import/export (quicker than table
copy for my needs), but again I will need to change the path.

How can I do this without having to check each component ?

Thanks

Ryan"Ryan" <ryanofford@.hotmail.com> wrote in message
news:7802b79d.0402130529.230f2596@.posting.google.c om...
> I'm building a DTS package on my development server which I want to
> move to my test server. I can save the file and import it, but there
> are connections etc that will be named differently.
> Is there a quick and easy way of changing the names of connections ? I
> also have some CSV files used for import/export (quicker than table
> copy for my needs), but again I will need to change the path.
> How can I do this without having to check each component ?
> Thanks
> Ryan

Have a look at some of these articles:

http://www.sqldts.com/default.aspx?101

One possible approach is to define global variables in the packages for the
connection properties. Then at the start of the package, set the connection
properties with a Dynamic Properties task. Since you can specify global
variable values on the command line using DTSRUN.EXE, this is also a handy
way to pass in the properties from a batch file.

Simon

Move database from SQl server 2000 to 2005

How to import database in SQL server 2005 from the SQL server 2000 ?

The Data Transformation Services (DTS) tool that you are familiar with in SQL Server 2000 has gone through its own transformation in SQL Server 2005. DTS is no more, but instead with SQL Server 2005 you get a new transformation tool named SQL Server Integrated Services (SSIS). SSIS is much improved over the old DTS.

Please go here for more information.

http://www.databasejournal.com/features/mssql/article.php/3580216