Re: Convert SQL2005 to MS Access

On Tue, 24 Jul 2007 18:10:41 -0700, JosephWee04@xxxxxxxxx wrote:

What licensing issues? SQL Server 2005 comes with SSIS, doesn't it? No
special license required.

-Tom.

Hi all,

I am currently working on a project whereby I would need to create a
function that will convert an existing SQL 2005 Express database into
an Access 2003 database. I was initially thinking about SSIS but due
to licensing issues I have dropped that method. Has anyone does this
before? Does anyone know of a third party component that does this?

I did read that Attached tables would be the way to go but I am just
wondering is there any alternative as synchronization would be an
issue.

Thanks guys for having a think.

Joe

.

Relevant Pages

  • Re: Licensing - rumours and flotsam floating around my company. Whats the status?
    ... the only licensing requirement for SQL Server CE ... > want to go to SQL Server CE for my database needs. ... > I have a bunch of PDAs that will run SSCE. ...
    (microsoft.public.sqlserver.ce)
  • RE: Tool for migrating from one db schema to another?
    ... even schedule it to run using SQL Server Agent on regular basis (SQL Server ... Sommarskog has mentioned SSIS does not come with the Express edition. ... database would be the key. ... a few hundred tickets to migrate to the new system. ...
    (microsoft.public.sqlserver.tools)
  • RE: ODBC Imports of entire Database
    ... In every database there is a system view called sys.tables. ... When I run the wizard it does not give me the option to copy the entire ... I can schedule SSIS packages but can't get them to just import the data ... Creating Packages Using the SQL Server Import and Export Wizard ...
    (microsoft.public.sqlserver.dts)
  • SSIS import db not able to connect
    ... I'm trying to import a database from machine B which is a sql ... connect to sql server on machine B, I've try every possible way I can think ... using the sa account, etc.) and SSIS can't ... running 2k to another machine running SSIS. ...
    (microsoft.public.sqlserver.dts)
  • Licensing - rumours and flotsam floating around my company. Whats the status?
    ... want to go to SQL Server CE for my database needs. ... Due to some unclear wording on the licensing page some co-workers are very ... I have a bunch of PDAs that will run SSCE. ... When the product is mature enough, it will sync data against an SQL server ...
    (microsoft.public.sqlserver.ce)