ASP.NET, SQL Server, WPF, C#, VB.NET

Hi, 
 
SSMA Access is the tool for you 
 
http://www.microsoft.com/sql/solutions/migration/default.mspx 
 
It is on beta phase but it is working very good. You can convert the Access 
 
schema inside the SSMA workspace and script it to a text file if you want. 
 
Of  course you can move data and schema directly to SQL Server. The problem 
 
with SSIS(former DTS) is that not all schema objects are moved to SQL 
 
Server. 
 
Constraints,default values are not migrated by SSIS. SSMA handles all that 
 
correctly. 
 
"David" <dlchase@lifetimeinc.com> wrote in message 
 
news:enuWE13pGHA.4188@TK2MSFTNGP04.phx.gbl...

Where can I find info. on how to import Access tables into SQL 2005?  I have 
 
used it in SQL 2000 using DTS but not in 2005.  Also, can I save my 
 
importing scripts (development) for running on a different server 
 
(production)?  Thanks. 
 
David

SSMA can migrate DATA as well. It fixes on the fly problem with date values 
 
below the range.Ofcourse you can also use SSIS export\import wizard. 
 
Just run dtswizard.exe and follow the wizard guide . 
 
"David" <dlchase@lifetimeinc.com> wrote in message 
 
news:OFYSb04pGHA.4196@TK2MSFTNGP04.phx.gbl...

DTS has been replaced with SQL Server Integration Services (SSIS) in 
 
SQL-Server 2005; see: 
 
http://msdn2.microsoft.com/en-US/library/ms141026.aspx 
 
-- 
 
Sylvain Lafontaine, ing. 
 
MVP - Technologies Virtual-PC 
 
E-mail: http://cerbermail.com/?QugbLEWINF 
 
"David" <dlchase@lifetimeinc.com> wrote in message 
 
news:enuWE13pGHA.4188@TK2MSFTNGP04.phx.gbl...

I already have the SQL Server database designed because I wanted to remove 
 
some of the spaces in field names, etc.  I will want to just import the data 
 
and not the schema.  Does this make a difference in your responses?  Thanks. 
 
David 
 
"Gil Lapid Shafriri" <gilsh@microsoft.com> wrote in message 
 
news:ObI9FO4pGHA.524@TK2MSFTNGP05.phx.gbl...