If you're just creating a few tables, it may not be an issue, but if there are a ton of tables with lots of fields of different data types, you may run into issues. sql file/code is to set up a data source for mysql and just use odbc to access the database itself.īear in mind that there are real and very annoying differences between mysql and t-sql that can make migration a pain. ![]() Much faster and SSMS won't freak out.Īnother alternative option to running the. You didn't say how big the file was, but if it is quite large and has the insert statements (data as well as schema), then you'll probably want to run by CLI using sqlcmd command. Note: If you're creating a database for the very first time and you have the rights to do it, it's assumed you're doing it on a test or development server and not on a production server. ![]() statements to create the schema/structure and not just insert statements for the data.Ĭheck the top of the file to make sure that it is first selecting the correct database, if not add a USE statement to select the correct database. Solution Let's step through the database creation process using SQL Server Management Studio (SSMS). This assumes it has all of the create table etc. ![]() sql file which contains SQL statements, you can just copy and paste the contents (or open the file in a query window) and run it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |