SDF to MDF Conversion

Version 4
1

Hi,

While trying to convert SDF to MDF “the migrate.sql splits into two as migrate_0.sql and migrate_1.sql”.

Why does this splits into two. Is it because of the size of the SDF too big to convert to MDF?

2

I believe because the SQL CE Toolbox tool has a maximum length of the migrate.sql file, so it needs to split into multiple files.

In this case, just run one after the other - so migrate.sql (if exists), then migrate_0.sql, migrate_1.sql, etc. I believe this is also mentioned in the tutorial. It will not affect the end result.

2 Likes
3

Hi,

Thanks for your update…

How can we put the connection string for this if two SQL files are there?

4

If I remember right don’t you import those files into your new SQL database?

5

Ok so MDF is not used like an SDF many people get this confused. Here is the propper way to convert from sdf to SQL Express and it involves scripting the database.

1 Like
6

Hi Kendash,

Thanks for the update. This worked fine…