Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PaulXLE
Starting Member
3 Posts |
 Posted - 2008-12-16 : 12:56:54
|
| I'm trying to upsize an Access database to SQL Server 2000I'm using Access 2007, and the SQLServer database is on-line (hosted by Fasthosts) and it's version 2000Following Fasthosts instructions I get to the point where I've specified the target database using the Wizard, selecting a "machine data source" entry I've made, which I know works okay (Access can see the data on the SQLServer using it)Having entered the password to "SQL Server Login" I immediately get a dialog box "Upsizing Wizard" and an error "Invalid use of Null".If I get the password wrong, I get a suitable error - not the above, so it does appear to be getting somewhere... and it doesn't matter which Access database I try and upsize, including a totally empty one.I have seen mention of this error elsewhere on t'internet, but never with an explanation.I'd be very grateful if anyone could help! TIAPaul |
|
|
PaulXLE
Starting Member
3 Posts |
Posted - 2008-12-19 : 14:00:33
|
| Okay, replying to self... nobody knows about the Null thing... fair enoughSo, I did this... I upsized my Access database to my local machine, running SQL Server Express, which worked fine.I then scripted the entire database, and then ran this script on the remote SQL Server, and lo, my database is upsized!My question is... ah but is it? I'm no expert (yeah, you could tell) but is this a valid way to do the job, or does stuff get lost when you do that scripting thing? So far the data looks good.Paul |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
PaulXLE
Starting Member
3 Posts |
Posted - 2008-12-23 : 10:49:36
|
| Thanks for that adviceHowever... as the SQL Server in question is hosted elsewhere, I don't think I can run a Restore on it, at least I don't see how to.In the hosting company's instructions for restoring a database they actually recommend the scripting method to restore a database.my database is quite simple, lots of tables but no great complexity, no queries to carry over, just data really.you said I might lose some stuff... what sort of stuff should I be worried about, presumably not actual data?TIAPaul |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Upsizing Access to SQLServer "invalid use of null"