ACCESS2SQLSERVEREXPRESS

Hello,

First of all, please excuse my english... I'm french :-D

Can someone give me a way to convert an Access2 DB to a SQL Server 2005 Express ?

Is it possible ?

Thanks,

I managed to export datas from ACCESS2 DB in text format.

Can I insert from a text file datas in SQLExpress ? Even if I don't need all the fields ?

Thanks,

|||

Is this a silly question ?!?

I read that SSIS is not in SQL Server Express and I'm trying to find a way to import Access2 DB to SQL Server Express DB...

|||

There is tool from Microsoft to convert Access Database into SQL Server 2005 database. I have no link for it. You can search it from Microsoft's website.

|||

For importing text files into SQL Express, take a look at the BCP tool, more information is in the BOL.

You can also take a look at the SQL Server Migration Assistant for Microsoft Access. I'm not sure this tool is capable of working with Access 2.0 databases, since that version hasn't been supported for some time now.

Another possibility would be to try the built in Export functionality in Access to export data directly to SQL Server.

Mike

|||

Thank you very much ! I have never heard about this SQL Server Migration Assistant, even when I was searching in MS website. It is exactly what can help me and it works with Access2.

Thanks a lot again

Best regards

Nico

Access java webservices from CLR function on sql server in DMZ.

Hello,
First excuse me for my bad english.
I have developed a sql server funtion CLR calling external webservices (java
).
Everything works perfectly when i execute the function on my test server.
But i need to deploy it on my production sql server 2005, but the cluster is
in DMZ (private network), and from it i don't have a direct access on
internet.
What is the best secure solution :
- NAT?
- install a sql express on the web server, and connect the cluster on it?
thanks for your response.
DraganNo response for me doesn't matter
I found my answer alone. For everyone who wan't to use a CLR UDF table
fonction who get some data from distant web service, and where the sql serve
r
was in private network, behind a webserver simply mail me
Have a nice weekend
"Draggi" wrote:

> Hello,
> First excuse me for my bad english.
> I have developed a sql server funtion CLR calling external webservices (ja
va).
> Everything works perfectly when i execute the function on my test server.
> But i need to deploy it on my production sql server 2005, but the cluster
is
> in DMZ (private network), and from it i don't have a direct access on
> internet.
> What is the best secure solution :
> - NAT?
> - install a sql express on the web server, and connect the cluster on it?
> thanks for your response.
> Dragan|||> I found my answer alone. For everyone who wan't to use a CLR UDF table
> fonction who get some data from distant web service, and where the sql
> server
> was in private network, behind a webserver simply mail me
Why not post your solution here so that others with the same problem can
easily find the answer?
Hope this helps.
Dan Guzman
SQL Server MVP
"Draggi" <Draggi@.discussions.microsoft.com> wrote in message
news:08984EC0-25A3-4E42-BB63-8E291C275BF1@.microsoft.com...[vbcol=seagreen]
> No response for me doesn't matter
> I found my answer alone. For everyone who wan't to use a CLR UDF table
> fonction who get some data from distant web service, and where the sql
> server
> was in private network, behind a webserver simply mail me
> Have a nice weekend
>
> "Draggi" wrote:
>