SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Oct 2004
    Location
    Canada, Ontario
    Posts
    85
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MS Access to MSSQL, 'Generate Create Scripts' dont include data. Ideas?

    As said in title: Im trying to get a Access database into MSSQL, enterprise manager does this (uploads data as well) but I need the scripts to do it. "Generate Create Scripts" does this but just recreates the structure. It doesnt include the data (Ie. "insert into person... values...").

    I need the create scripts as well as the data scripts to fully recreate the database in MSSQL.

    Any suggestions welcome. I tried searching forums but no matches 'for access scripts'.

    edit: Because I have the access database converted onto my server mssql database I can use either database to get the data scripts from but... I tried many things and downloaded programs with no luck.

  2. #2
    SitePoint Enthusiast
    Join Date
    Oct 2004
    Location
    Canada, Ontario
    Posts
    85
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    http://www.codeproject.com/dotnet/ScriptDatabase.asp

    After roughly an hour of trying to find things my partner found a nice script that does it all. It does script much of the less useful parts (default system procedures etc), but something that can easily be deleted from the text files.

    Just thought Id post this for other people that may have the same problem.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •