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 |
|
radarman012000
Starting Member
1 Post |
 Posted - 2008-01-12 : 08:05:36
|
| Hi, newbie here with a simple?(maybe)question.I have an Access Database that I have imported into SQL Server2000 and that worked great, but now I have to get it into 2005. My question is, How can I get the tables and all info in the tables into an SQL Script so I can run that script on the 2005 server?The SQL 2000 is on my dev server and I have all the Tools, (Ent Manager, Query Analyzer,etc...) but the 2005 Server is Godaddy's and they only have the basic web interface. I can run Sql files and create databases and tables, but thats about it. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-12 : 09:40:14
|
| You can script out tables in 200 using enterprise manager. Just right click on table and select script file as option to generate the complete script. Then run it against 2005 interface to create it there.Regarding data you may use the export import wizard to move it to new db. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-12 : 12:09:17
|
| SSIS package copies schema as well. |
|
|
|
|
|
|
Data Transformation