access to ms sql conversion without ms sql

[jez]

Hi all,

I hope this is fairly easy.
I am not a .NET developer, normally on the other side of the tracks (*nix).
Anyway, i am helping a friend to move a .NET app from one host to another, it has an access db but the new host only gives MS SQL.

As i understand it, if i convert the database using the upsizing wizard and change some settings in the web.config file, we should be able to get the DB working.

Now here is my problem, i have access to Access (no pun intended) but i have no other MS SQL server other than the one on the new host.
I cannot seem to figure out a intermediate sql dump file. The wizard only wants to connect directly to a SQL server.

Anyone know how i can get round this ?

(I tried creating a direct DSN to the host, but permission denied).

Thanks in advance.

Jez

 

[RiverGuy]

Download SQL Server Express, which is a free, scaled down version of SQL Server 2005. The syntax is the same as paid versions of SQL Server. You can find it on Microsoft's website.

 

[jez]

Thanks for the suggestion, I'll give it a try.

 

[MasterRacker]

Check out your upsized DB carefully. I did this once a few years ago and all my text fields were converted to unicode. Not fatal, but you want to look for quirky things like that.

_____
Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[jez]

Thanks, although it seems to have worked ok.

To be honest with you, the data types changing are the least of my worries as it seems the app that i am moving was developed for low trust setttings in the .NET, but the new host only allows high trust settings. Not sure what all this means but the client can see their DB as MS Sql, so that is something.

I think it is time to post in the .NET forum.

Thanks for your input, the DB is in a much better place now.